<% 'Variables = Table Width, URL Target Page, text position, table align, margin, font-weight, font-size, any other sytles showwinners 780, 64, "winners.asp?source=6", "right", "center" ,"0px", "bold", "Arial, Helvetica, sans-serif", "10px", "" %>
 
  Buying Real Estate
Selling Real Estate
Relocating
Maryland Information Center
Real Estate Education
Contact
Homes for Sale in Maryland

ThinkNewman.com is the resource for your real estate needs. We provide you with access to the local MLS and service to Baltimore - Washington Metro area.

Find Your Home’s Value

Enter your zip code below to find out how much your home is worth.
 
Site Map
Property Search for Maryland

Are you looking for homes that are for sale? My website provides you with free access to the MLS system in Maryland that is continually updated throughout the day!

 
County:  
Featured Properties
View our homes listed in Maryland.
View our Listings  See Featured Listings
<% set rs = conn.execute("Select featuredlistings.show_home_pic, featuredlistings.show_home_price, featuredlistings.show_home_address, listing.price, listing.id, listing.pic1, featuredlistings.listing_id, featuredlistings.active, listing.address1 from listing INNER JOIN featuredlistings ON listing.id = featuredlistings.listing_id where realtor="& iAgentID &" and active=1") If rs.eof then %> <% else %> <%end if set rs = conn.execute("Select featuredlistings.show_home_pic, featuredlistings.show_home_price, featuredlistings.show_home_address, listing.id, listing.pic1, featuredlistings.listing_id, featuredlistings.active, listing.address1 from listing INNER JOIN featuredlistings ON listing.id = featuredlistings.listing_id where (realtor="& iAgentID &") and (active=1) AND (show_home_pic =1 OR show_home_price =1 AND show_home_price =1)") If rs.eof then %> <% else %>
 
<% dim iOrderBy, strOrderby, iDescAsc, strAscDesc iOrderBy = RandomNumber(5) If iOrderBy = 1 then strOrderby = "listing.id" ElseIf iOrderBy = 2 Then strOrderby = "listing.city" ElseIf iOrderBy = 3 Then strOrderby = "listing.targetState" ElseIf iOrderBy = 4 Then strOrderby = "listing.price" Else strOrderby = "listing.address1" End If iDescAsc = RandomNumber(1) If iDescAsc = 1 then strAscDesc = "ASC" Else strAscDesc = "DESC" End If 'Show featured homes if selected to be on home page set rs1 = conn.execute("Select listing.address1, listing.city, listing.targetState, listing.price, listing.pic1, featuredlistings.show_home_pic, featuredlistings.show_home_price, featuredlistings.show_home_address, listing.id, featuredlistings.listing_id, featuredlistings.active, listing.address1 from listing INNER JOIN featuredlistings ON listing.id = featuredlistings.listing_id where (realtor="& iAgentID &") and (active=1) and (featuredlistings.show_home_pic=1 OR featuredlistings.show_home_price=1 or featuredlistings.show_home_address=1) order by "& strOrderby &" "& strAscDesc &" LIMIT 1") If not rs1.eof then If (NOT isnull(rs1("pic1"))) AND (rs1("pic1") <> "") and (rs1("show_home_pic")=1) then response.write "
" End if If (rs1("price") <> "") AND (rs1("show_home_price") = 1) Then response.write "
"& formatcurrency(rs1("price")) &"
" Else response.write "
" End If If (rs1("address1") <> "") AND (rs1("show_home_address") = 1) Then response.write "
"&rs1("address1")&"
" Else response.write "
" End If End if set rs1 = nothing Function RandomNumber(intHighestNumber) Randomize RandomNumber = Int(Rnd * intHighestNumber) + 1 End Function %>
 
Showcased Homes


Please take a look at my Showcased Homes. These homes are absolutely beautiful and are priced right. Please select an address from the list below.
 
 
 
<% end if %>
  Maryland Real Estate Information Center
 
Meet Your Agent John Newman
Keller Williams Flagship of Maryland The Answer Team Real Estate Network
  Agent Control Panel
   Select your login option below:
   
Vendor
  © 2002 The Rrien Group, Ltd.
  All Rights Reserved
Home Search | Featured Listings | Buying | Selling | Relocating | Information | Education
Contact | About | All Rights Reserved | Terms of Use | Site Map
 
Mojo Web Solutions -  Maryland Real Estate Web Design