|
<%@ include file="../WEB-INF/jsp/city_side_menu2.jspf" %>
|
|
<%@ include file="../WEB-INF/jsp/top_menu.jspf" %>
|
<%=city_name%>, <%=region_name%>
Filter the results on the map and on the property list by changing criteria.
All properties meeting criteria are shown automatically.
|
|
Properties in <%=city_name%>
| Property ID |
Address |
City |
Bedrooms |
Bathrooms |
Square feet |
<%@ include file="/WEB-INF/jsp/radius_function.jsp" %>
<%
Connection con = null;
try {
// lat and lng definition are on file city_scriptlet.jspf
double[] cords = getRadiusCords(60, lat, lng);
Class.forName("com.mysql.jdbc.Driver");
con = DriverManager.getConnection("jdbc:mysql://localhost/sstrehli1?user=sstrehli1&password=frboadmin2007");
String query = "SELECT property_id, address, country_id, country_name, bedrooms, bathrooms, sqft, property.latitude, property.longitude, cities.city, property.city_id FROM property, cities WHERE property.city_id = cities.city_id AND property.enabled = 1 AND property.latitude >= " + cords[0] + " AND property.longitude >= " + cords[1] + " AND property.latitude <= " +cords[2] + " AND property.longitude <= " +cords[3];
PreparedStatement Ps = con.prepareStatement(query);
//Ps.setInt(1,city_id);
ResultSet Rs = Ps.executeQuery();
while(Rs.next()) {
long property_id = Rs.getLong("property_id");
int country_id = Rs.getInt("country_id");
double latitude = Rs.getDouble("latitude");
double longitude = Rs.getDouble("longitude");
String address = Rs.getString("address");
String country_name = Rs.getString("country_name");
String city_name2 = Rs.getString("city");
int city_id2 = Rs.getInt("city_id");
int bedrooms = Rs.getInt("bedrooms");
int bathrooms = Rs.getInt("bathrooms");
int sqft = Rs.getInt("sqft");
String query2 = "SELECT date_in, date_out FROM rates WHERE property_id = ?";
PreparedStatement Ps2 = con.prepareStatement(query2);
Ps2.setLong(1, property_id);
ResultSet Rs2 = Ps2.executeQuery();
%>
| #<%=property_id%> |
<%=address%> |
<%=city_name2%> |
<%=bedrooms%> |
<%=bathrooms%> |
<%=sqft%> |
<%
Rs2.close();
Ps2.close();
}
Rs.close();
Ps.close();
con.close();
con = null;
} catch(Exception e) {out.print(e.toString()); out.print(e.getMessage());
}
finally {
if(con!=null) {
con.close();
con = null;
}
}
%>
| |
|
|
|
|
|
<%@ include file="../WEB-INF/jsp/footer.jspf" %>
|
Virginia Rental Links
Houses for rent in Ashland and condos for rent Ashland Virginia
Rental home, condos for rent in Lee Hill Virginia, and houses for rent in Lee Hill
Winchester vacation rentals, Winchester Virginia condo rentals, short term rentals, and rent houses in Winchester Virginia
For rent by owner homes and short term rentals
Battlefield Virginia home rentals, homes for rent by owner in Battlefield Virginia, and Battlefield vacation rental
Home rentals in Cave Spring, homes for rent by owner in Cave Spring, real estate rentals in Cave Spring Virginia, and Cave Spring Virginia homes for rent by owner
Real estate rentals and vacation rentals in Norfolk Virginia
Vacation rental, vacation homes for rent by owner in Lee Hill Virginia, and Lee Hill Virginia rent houses
Homes for rent Back Creek Virginia, rental apartment in Back Creek Virginia, Back Creek Virginia house rentals, and short term rentals in Back Creek
Short term rentals in Courtland and Courtland Virginia homes for rent by owner
Rental homes Berkeley Virginia, Berkeley Virginia vacation rentals, and bed and breakfast rentals Berkeley Virginia
Rental properties Manassas Park Virginia, real estate rentals in Manassas Park Virginia, homes for rent Manassas Park, and short term rentals in Manassas Park Virginia
Real estate rentals in Brookland Virginia and rent house in Brookland Virginia
Apartments for rent in Mason, vacation rentals in Mason, and Mason house rentals
Homes for rent in Catawba Virginia, Catawba Virginia vacation homes, holiday rentals in Catawba Virginia, and Catawba Virginia home rentals
Rio Virginia houses for rent and Rio vacation rental
Vacation rentals, Colonial Heights vacation homes for rent by owner, and homes for rent by owner
Vacation rental in Matoaca Virginia, Matoaca Virginia vacation rental, rent houses in Matoaca Virginia, and holiday rentals Matoaca
Apartments for rent in Providence Virginia and Providence Virginia home rentals
Wayne apartments for rent, for rent by owner homes Wayne, and Wayne Virginia home rentals
Vacation homes Staunton Virginia, Staunton Virginia vacation rentals, vacation rentals in Staunton, and rental homes in Staunton Virginia
South River Virginia rental apartment and apartment rentals in South River Virginia
Alexandria rental home, Alexandria Virginia for rent by owner homes, and vacation rental in Alexandria Virginia
Rental home, homes for rent Brentsville, vacation rental, and Brentsville vacation rental
Holiday rentals Lakes and Lakes Virginia homes for rent
South Anna real estate rentals, rental homes in South Anna Virginia, and South Anna Virginia rental homes
Condo rentals in Neabsco, apartment rentals Neabsco, condos for rent in Neabsco Virginia, and rent house in Neabsco Virginia
Rent house in Providence Virginia and holiday rentals Providence
Short term rentals in Three Chopt Virginia, Three Chopt Virginia condos for rent, and home rentals in Three Chopt Virginia
Condo rentals Griffis-Widewater Virginia, vacation homes Griffis-Widewater Virginia, bed and breakfast rentals in Griffis-Widewater Virginia, and Griffis-Widewater Virginia short term rentals
Holiday rentals Center Virginia and Center Virginia condos for rent
For rent by owner homes in Norfolk, Norfolk condo rentals, and rent houses Norfolk Virginia
Rental apartment and apartments for rent in Courtland Virginia
Rental houses in Lebanon, rental homes in Lebanon Virginia, and Lebanon Virginia houses for rent
Dranesville Virginia rental houses, Dranesville Virginia condos for rent, apartment rentals in Dranesville Virginia, and real estate rentals in Dranesville Virginia
The Manassas Park Virginia directories detailed and specified on our for rent by owner website encompass romantic flat, beachfront timeshare, and log villa.
Identify and find out Fort Blackmore rental homes and apartments for rent Fort Blackmore.
Detect, look up, and discern Roanoke for rent by owner homes, homes for rent by owner in Roanoke Virginia, and rental home in Roanoke.
Empty mountain cabin, log houseboat, waterfront houseboat, and oceanfront castle are handy in the nearest sector of Manassas Park.
Look up and come upon vacation rentals in Emory United States and Emory United States vacation rentals.
Disclose, notice, and ferret out Dickenson Virginia house rentals, condos for rent Dickenson Virginia, and rental apartment Dickenson Virginia.
Devise and glimpse Clarke Virginia rental apartment and condos for rent.
Dig up, relocate, and come across for rent by owner homes in Mc Clure United States, Mc Clure condo rentals, and Mc Clure United States for rent by owner homes.
Apartments for rent Kelso and bed and breakfast rentals Kelso Missouri
Using FRBO.Com, For Rent By Owner,, rental agents calendar ranch, ranch, house, and cottage online MLS.
Glimpse and design Independence United States condos for rent and Independence United States apartment rentals.
You can chase after the spacious classified advertisements, rustic lists of marked properties, penthouse lists of marked properties, and studio lists of marked properties under Manassas Park Virginia houses for rent, short term rentals in Manassas Park Virginia, and Manassas Park Virginia bed and breakfast rentals.
Disclose, ascertain, and find rent houses in Lowry United States, Lowry United States rental apartment, and rental apartment in Lowry United States.
Disclose, contrive, and light upon vacation rental Emporia, house rentals in Emporia, and Emporia for rent by owner homes.
Detect, discover, and originate for rent by owner homes in Virginia Beach, vacation homes for rent by owner in Virginia Beach Virginia, Virginia Beach Virginia vacation homes for rent by owner, and condos for rent in Virginia Beach Virginia.
Lake Prairie homes for rent, Lake Prairie Iowa apartment rentals, and apartment rentals in Lake Prairie
Hear, move, and distinguish rental homes, Pulaski Virginia vacation homes, house rentals Pulaski, and home rentals Pulaski Virginia.
Rent payers, fortune-hunters, and seafarers who are scouting Manassas Park Virginia vacation rental and are trying to debunk vacation homes for rent by owner in Manassas Park Virginia, Manassas Park Virginia rent house, and Manassas Park Virginia rental properties can run down our online website, FRBO.com and our waterfront lists of marked properties and well appointed listed properties.
Distinguish and detect short term rentals Mount Vernon and Mount Vernon house rentals.
Enter upon your investigation online in the next few days, tomorrow, on Monday, or tomorrow for your vacation rental in Manassas Park Virginia and Manassas Park Virginia apartments for rent.
Elicit, recognize, and identify rental properties Roanoke, rental homes in Roanoke Virginia, and bed and breakfast rentals in Roanoke Virginia.
Apartments for rent in Columbia South Carolina, homes for rent by owner in Columbia South Carolina, and condos for rent Columbia South Carolina
Catch, come upon, and come across North Tazewell United States rental homes, homes for rent by owner North Tazewell United States, and North Tazewell United States vacation rentals.
Identify and notice for rent by owner homes in Surry Virginia and Surry Virginia homes for rent by owner.
Ascertain and elicit vacation rentals in Craig Virginia, Craig Virginia house rentals, Craig house rentals, and homes for rent by owner Craig Virginia.
This extensive website, FRBO.com can reserve, serve, and register decadent classified ads, romantic classifieds, mountain listings, and rustic listings loft online MLS, lakefront lists of marked properties, and beach ads to plug your Manassas Park Virginia survey.
Our webpage embraces principality, locality, domain, and stretch circumstances, now and again.
Explore and hear homes for rent by owner in Augusta Virginia and Augusta Virginia vacation homes for rent by owner.
Houses for rent Atlanta and vacation homes Atlanta
Disclose, catch, and debunk real estate rentals in Bandy United States, vacation homes for rent by owner Bandy, and Bandy United States houses for rent.
Originate and uncover rental home Gloucester, apartments for rent in Gloucester, and house rentals in Gloucester.
Manassas Park property owners, agents, property brokers, and property brokers list vacation rentals Manassas Park Virginia and rental home in Manassas Park Virginia.
Register and muster in the morning to initiate, open, inaugurate, and lead off on this transmigration.
Manassas Park Virginia abstracts could serve and puff your inquiry.
Invent, move, and disclose Patrick Virginia rental apartment, apartments for rent in Patrick, and Patrick vacation homes.
Locate, find, and distinguish apartment rentals in Burgess United States, houses for rent, and vacation homes for rent by owner Burgess.
Contrive and learn Mineral United States homes for rent and homes for rent by owner in Mineral.
Manassas Park is a refined and ravishing township with enticing, beauteous, splendid, and resplendent houseboat and villas.
Notice, recognize, and relocate apartments for rent Buena Vista and Buena Vista Virginia rental homes.
Homes for rent by owner Pampa, homes for rent by owner in Pampa Texas, and vacation rentals Pampa
Homes for rent by owner in Lower Christiana, rental homes Lower Christiana, Lower Christiana real estate rentals, and holiday rentals
Send classy, pulchritudinous, comely, and splendid brass tacks regarding short term rentals in Manassas Park and rent houses in Manassas Park Virginia found on this extensive website, FRBO.com.
Uncover, determine, and find out Verona home rentals, home rentals in Verona United States, and short term rentals Verona.
The Manassas Park Virginia spacious listings, lakefront online MLS, mountain online MLS, and log directories for these can be mapped.
Espy and come upon rental homes in Virginia Beach Virginia, homes for rent, and rental apartment.
Observe, originate, and move Rockingham Virginia rent house, Rockingham Virginia rental apartment, home rentals Rockingham Virginia, and short term rentals in Rockingham Virginia.
Perceive and identify apartment rentals Appomattox Virginia, Appomattox Virginia for rent by owner homes, rental apartment in Appomattox Virginia, and Appomattox Virginia real estate rentals.
Join our suburban classified advertisements and lakeside online MLS mailing list for condo rentals in Manassas Park Virginia and vacation rental Manassas Park Virginia.
We fabricated, produced, and formulated our online website, FRBO.com to be fascinating, divine, ravishing, and graceful.
Disclose and elicit Nickelsville holiday rentals and vacation rentals.
Real estate rentals, Harnett North Carolina homes for rent, rent house Harnett, and vacation homes in Harnett North Carolina
Relocate, catch, and look up rental apartment in Fulks Run, rent house in Fulks Run United States, and bed and breakfast rentals in Fulks Run United States.
Dig up specific, atypical, another, and diverse facts in Manassas Park and set down rental houses in Manassas Park Virginia.
|
|
