Header
Search our hundreds of rental units. We offer 1, 2 & 3 bedroom apartments, town homes and even some single family homes*.
<& ./temps/search_box.html, RS => $RS,bedrooms=>$ARGS{bedrooms},baths=>$ARGS{baths},city_name => $ARGS{city_name},state_code => $ARGS{state_code},floor=>$ARGS{floor},utilities=>$ARGS{utilities},price_min=>$ARGS{price_min},price_max=>$ARGS{price_max} &>

Search Results:

THE PROPERTIES BELOW ARE MANAGED, BUT NOT OWNED BY MOLDEN REAL ESTATE COMPANY

<&| ./temps/props_loop.html, upload => $upload, allprops => $allprops&>
Property
City
State
Type
Price
Availability
$city
$state
$prop20a
$$priceis /mo.
$avail


Interested in buying or selling a home? We can HELP! Call for details! 540.662.4116
COMING SOON!
NEW 55 PLUS COMMUNITY - ALL UTILITIES INCLUDED, HANDICAP ACCESSIBLE, SECURE COMMUNITY. CLICK HERE TO GET MORE INFORMATION OR TO BE ADDED TO OUR WAITING LIST!


2400 Valley Ave., Winchester VA 22601 540662-4116 home rentals buying application about contact
 

 
<%init> use CGI; my $cgi= new CGI; use RSDB::DB; my $db= new RSDB::DB($cgi); my @retval; my @retval2; my $CMS = '16'; my $RS = '16'; my $AGENTID = '0'; my $SiteNM = "Molden Realty"; my $jREF2 = $db->Establish("realestate","id"); my %rsf = %$jREF2; my $upload = "http://$rsf{$RS}{siteaddress}//UserFiles/Image/"; my $page = "listings.html"; my $ids = $ARGS{id} eq "" ? "" : "&id=$ARGS{id}"; my $sort = $ARGS{sort} eq "" ? "Porder" : $ARGS{sort}; my $where = $ARGS{id} eq "" ? "" : " AND agentid = $ARGS{id}"; $ARGS{floor} = $ARGS{floor} == 0 ? "" : $ARGS{floor}; $where = $AGENTID eq "" || $AGENTID == 0 ? $where : " AND agentid = $AGENTID"; $where = $ARGS{city_name} ne "" ? ($where . " AND city_name = '$ARGS{city_name}'") : $where; $where = $ARGS{state_code} ne "" ? ($where . " AND state_code = '$ARGS{state_code}'") : $where; $where = $ARGS{floor} ne "" ? ($where . " AND floor = '$ARGS{floor}'") : $where; $where = $ARGS{utilities} ne "" ? ($where . " AND utilities = 1") : $where; $where = $ARGS{price_min} ne "" ? ($where . " AND Pricemin > '$ARGS{price_min}'") : $where; $where = $ARGS{price_max} ne "" ? ($where . " AND Pricemin < '$ARGS{price_max}'") : $where; $where = $ARGS{bedrooms} ne "" ? ($where . " AND Bedrooms >= '$ARGS{bedrooms}'") : $where; $where = $ARGS{baths} ne "" ? ($where . " AND Baths >= '$ARGS{baths}'") : $where; $where .= " AND type = 'MANAGED'"; my $allprops = "select * from props where Dbid > 0 AND realestateid = '$RS'$where order by $sort"; my @auto=$db->simple_select("select * from contentpages where Pagename = 'apartments' and realestateid = '$CMS'");