<%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%> <% Dim dbPath Dim dbConn Dim Conn Dim SQL, RS dbPath = Server.MapPath("dbm/mercado.mdb") dbConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & dbPath & ";Persist Security Info=False" Set Conn = Server.CreateObject("ADODB.Connection") Conn.Open dbConn %> Mercado Advanced Realty

Featured Homes

<% SQL = "SELECT * FROM featured ORDER BY Date DESC" Set RS = Conn.Execute(SQL) If Not RS.EOF Then RS.MoveFirst Do Until RS.EOF If Not RS.EOF Then Response.Write "" & vbcrlf RS.MoveNext End If Loop Else Response.Write "

No Featured Homes Today

" & vbcrlf End If RS.close Set RS=Nothing %>

Home Sweet Home

Communities Served: Raleigh, Clayton, Cary, Garner, Willow Springs, Fuquay Varina, Angier, Smithfield, Apex, Holly Springs, Knightdale, Rolesville, Wake Forest, Wendell, Youngsville, Zebulon

Exceeding Clients Expectations Throughout Wake, Johnston, Harnett, and Franklin Counties. We have been in the residential real estate business for 9 years and are prepared to satisfy all your real estate needs with the highest standard of service, beyond Raleigh, to include Clayton, Cary, Apex, Willow Springs, Fuquay-Varina, Angier, Smithfield, Holly Springs, Garner, Wake Forest, Knightdale, Rolesville, Youngsville, Wendell, and Zebulon. We are proud to continue growing with the Triangle Area, and offer services, information, and guidance in any of these neighborhoods. Please call us or use our new e-mail address as you proceed with your home buying or selling efforts, and feel free to contact us with specific questions.

What's New!

<% SQL = "SELECT * FROM News ORDER BY Date DESC" Set RS = Conn.Execute(SQL) Dim NewsLimit NewsLimit = 0 If Not RS.EOF Then RS.MoveFirst Response.Write "
    " & vbcrlf Do Until NewsLimit = 8 If Not RS.EOF Then Response.Write "
  • " & RS("Date") & ": " & RS("Title") & "
    • " & vbcrlf RS.MoveNext NewsLimit = NewsLimit + 1 Else NewsLimit = 8 End If Loop Response.Write "
" & vbcrlf Else Response.Write "

No News Today

" & vbcrlf End If RS.close Set RS=Nothing %>

Maria Mercado

"It is my sincere goal to provide the finest Real Estate service possible. I am committed and dedicated to my profession. But most importantly, to treat all customers honestly, fairly and to give every client the level of service which EXCEEDS their expectations. I strive to be thorough, knowledgeable, courteous, competent, and accessible. As a full service, full time real estate agent I will promote your best interest from locating that special property or marketing a property for sale to the completion of the transaction. I am committed and dedicated to providing my clients with professional service for all their real estate needs."

Homeowner's Gallery

Get the stories and see the photos of some of our happy new homeowners!

>> Homeowner's Gallery
Agent WebMail
E-mail Address
Password
<% Conn.Close Set Conn = Nothing %>