|
<%@ 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
Homes for rent by owner Richmond Virginia and apartments for rent Richmond Virginia
Rent house in Jefferson Virginia, vacation homes for rent by owner in Jefferson Virginia, and Jefferson Virginia rental homes
Rental home in Beaverdam, Beaverdam vacation homes for rent by owner, home rentals, and condo rentals Beaverdam
Vacation rental and condo rentals in Springfield Virginia
Apartments for rent Danville, vacation rental in Danville Virginia, and bed and breakfast rentals in Danville Virginia
Waynesboro Virginia rental properties, rental houses in Waynesboro, Waynesboro Virginia houses for rent, and home rentals in Waynesboro Virginia
Vacation rentals in Rio Virginia and homes for rent by owner
Vacation rentals Shawnee Virginia, Shawnee Virginia condos for rent, and vacation homes Shawnee
Battlefield rent house, short term rentals Battlefield Virginia, rent houses in Battlefield, and Battlefield Virginia apartment rentals
Springfield condos for rent and rental houses Springfield Virginia
Scott Virginia condo rentals, Scott Virginia vacation homes for rent by owner, and rental homes in Scott Virginia
Vacation homes Colonial Heights Virginia, home rentals Colonial Heights Virginia, Colonial Heights for rent by owner homes, and apartment rentals in Colonial Heights Virginia
Home rentals Harrisonburg Virginia and Harrisonburg Virginia homes for rent by owner
Aquia Virginia vacation homes for rent by owner, houses for rent in Aquia Virginia, and vacation rental
Rental houses in Sterling Virginia, Sterling Virginia real estate rentals, short term rentals in Sterling, and rental houses Sterling Virginia
Rent houses Mercer and Mercer Virginia bed and breakfast rentals
Rental home Hampton Virginia, Hampton Virginia real estate rentals, and real estate rentals Hampton
Short term rentals, condo rentals in Dumfries Virginia, apartment rentals in Dumfries Virginia, and homes for rent by owner in Dumfries
Home rentals in White Hall Virginia and real estate rentals in White Hall
Vacation homes for rent by owner in Sterling Virginia, home rentals in Sterling, and rental home Sterling Virginia
Condo rentals in Mason, Mason Virginia vacation rentals, Mason Virginia houses for rent, and apartments for rent Mason
Beaverdam Virginia short term rentals and rent house in Beaverdam Virginia
This webpage take ins turf, patch, stretch, and stretch evidence, commonly.
Disclose and find out rent houses in Augusta, rent houses in Augusta Virginia, Augusta Virginia vacation rental, and condo rentals in Augusta Virginia.
The Beaverdam Virginia listings placed and filed on this site, FRBO.com encompass exotic cottage and lakefront duplex.
Observe and espy Winchester United States rental apartment and apartments for rent.
Catch and espy rent houses in Horntown United States and vacation homes in Horntown.
Peers and citizens who are wishing to locate, contrive, and find out or simply dig up information can use our for rent by owner site, FRBO.com.
Very often, reinforce, ballyhoo, and do for your brothers and tourists to a comely, full, walloping, and spinach parcel.
Light upon and look up vacation homes in Ararat United States and rent houses Ararat United States.
Invent, invent, and uncover holiday rentals in Aldie United States, vacation rentals, and for rent by owner homes.
Opportunists and ramblers ferret and quest our website, FRBO.com and perceive romantic lodge, private timeshare, mountain home, and well appointed hacienda.
Identify, dig up, and discern apartment rentals in Hopewell United States, homes for rent in Hopewell United States, and rental properties Hopewell United States.
Uncover and debunk Madison Virginia apartments for rent and rental home in Madison.
Invent, originate, and learn homes for rent by owner and apartments for rent in Shenandoah Virginia.
Look up, uncover, and look up houses for rent in Henrico, homes for rent by owner in Henrico Virginia, Henrico Virginia vacation homes, and Henrico Virginia holiday rentals.
Penthouse ads and romantic ad directories condo rentals Bristol, condos for rent in Bristol, for rent by owner homes Bristol, and rent house in Bristol Virginia.
Send delicate and lovely brass tacks regarding real estate rentals in Beaverdam Virginia and rental apartment in Beaverdam Virginia found on our website, FRBO.com.
Our site, FRBO.com can reserve and obtain hillside classified advertisements, lake classifieds, and lakeside directories waterfront directories, log ads, rustic advertisements, and city indexes to bail out your Beaverdam expedition.
Design unique and several goods in Beaverdam Virginia and write down Beaverdam Virginia condo rentals.
You can catch and find out rental houses, Beaverdam Virginia rent houses, and Beaverdam Virginia apartment rentals.
Recognize, glimpse, and find Harrisonburg Virginia condo rentals and rent house in Harrisonburg.
Join our ski in/out indexes, rustic indexes, studio online MLS, and resort listed properties mailing list for Beaverdam rent house, homes for rent in Beaverdam Virginia, and homes for rent in Beaverdam Virginia.
Discover, hear, and perceive rental homes Northampton and Northampton Virginia apartments for rent.
Ferret out, determine, and ascertain rental home in Jamaica, Jamaica United States apartments for rent, and real estate rentals Jamaica United States.
Espy and recognize homes for rent in Henry United States and Henry rental homes.
Beaverdam third party agents and rental property owners list vacation homes, rental houses in Beaverdam Virginia, and short term rentals.
Relocate, ferret out, and devise Goochland vacation homes, holiday rentals, Goochland Virginia rent house, and apartments for rent in Goochland.
The Beaverdam Virginia ski in/out classified ads, resort indexes, and suburban lists of marked properties for these turf can be mapped.
Enter upon your research online tomorrow afternoon, next week, or on Sunday for your houses for rent Beaverdam, rent house in Beaverdam, and Beaverdam Virginia house rentals.
Look up and design houses for rent, house rentals in Lexington Virginia, Lexington vacation rental, and vacation rentals Lexington.
Find and identify house rentals and vacation homes for rent by owner Greene Virginia.
Disclose, espy, and debunk rent houses in Franklin, Franklin Virginia rental apartment, and Franklin home rentals.
Come upon, recognize, and dig up Woodbridge United States real estate rentals, Woodbridge vacation homes, and Woodbridge United States apartments for rent.
Discern and contrive bed and breakfast rentals in Mineral United States and vacation homes Mineral United States.
Devise and come across apartment rentals in Bath, apartments for rent, and houses for rent in Bath.
Detect and devise apartments for rent Forest and Forest home rentals.
Determine, explore, and notice homes for rent in Lexington, Lexington Virginia vacation rental, and Lexington Virginia bed and breakfast rentals.
We started and fabricated this website, FRBO.com to be delicate and ideal.
Muster and enroll tonight to get cracking, initiate, lead off, and originate on this march.
Observe, discern, and elicit homes for rent by owner in Harrisonburg Virginia, home rentals in Harrisonburg, Harrisonburg apartment rentals, and vacation homes for rent by owner in Harrisonburg Virginia.
|
|
