|
<%@ 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
Hampton Virginia rent houses and Hampton Virginia apartments for rent
House rentals Manassas Virginia, holiday rentals Manassas, and vacation rental
Home rentals in Neabsco Virginia, vacation rental, short term rentals in Neabsco, and house rentals in Neabsco Virginia
Vinton Virginia condos for rent and Vinton Virginia real estate rentals
For rent by owner homes Roanoke, condos for rent, and Roanoke Virginia vacation homes
Rent house Tuckahoe, Tuckahoe apartments for rent, Tuckahoe rent houses, and vacation homes in Tuckahoe Virginia
Ashland rental apartment and houses for rent in Ashland Virginia
Sully vacation homes for rent by owner, Sully Virginia bed and breakfast rentals, and vacation homes for rent by owner Sully Virginia
Rental houses Hampton, rental houses, rental home in Hampton, and holiday rentals
Apartment rentals in Sugarland Run and Sugarland Run Virginia rental houses
Houses for rent in Suffolk, Suffolk holiday rentals, and rental houses in Suffolk
Homes for rent in Mason Virginia, condo rentals Mason Virginia, Mason homes for rent, and homes for rent Mason
Bed and breakfast rentals Sugarland Run and rental properties
Roanoke Virginia homes for rent by owner, for rent by owner homes in Roanoke, and rental apartment in Roanoke Virginia
Home rentals, Henry Virginia vacation rentals, Henry vacation homes for rent by owner, and Henry Virginia holiday rentals
Condo rentals and Woodbridge vacation rental
Vacation homes, vacation homes for rent by owner, and rental home in Chickahominy
Berkeley Virginia houses for rent, vacation rental, rent houses in Berkeley, and homes for rent by owner in Berkeley
Cave Spring rent house and short term rentals
Disclose and uncover rental home in Blackstone and Blackstone United States houses for rent.
Obtain, oblige, join up, and levy tomorrow afternoon to lead off, inaugurate, and launch on this run.
Pre-rented beachfront townhouse, oceanfront lodge, beach vacation home, and beachfront houseboat are nearly in the nearest patch of Western.
Contrive, identify, and invent vacation homes in Roanoke Virginia, Roanoke Virginia apartments for rent, Roanoke vacation homes for rent by owner, and home rentals Roanoke Virginia.
Devise and ferret out condo rentals in Chesapeake and homes for rent by owner in Chesapeake Virginia.
Recognize, contrive, and distinguish vacation homes for rent by owner in Prince William Virginia and Prince William rental houses.
You can notice, light upon, and invent home rentals in Western Virginia and rental houses in Western Virginia.
This site, FRBO.com does subsume discrete section studio, secluded, romantic, and well appointed cabin, ranch, house, and vacation homes.
Contrive and glimpse Swoope United States apartments for rent and rental apartment.
Move, contrive, and discover apartment rentals in Nuttsville United States, rent house in Nuttsville United States, and vacation homes for rent by owner Nuttsville United States.
Join our romantic ads and mountain ads mailing list for Western homes for rent and homes for rent by owner in Western Virginia.
Send grand, foxy, ravishing, and sublime conclusions regarding houses for rent, Western apartments for rent, and vacation rental in Western Virginia found on our site, FRBO.com.
Recognize, come upon, and identify Chesapeake Virginia rent houses, rent house, and Chesapeake Virginia vacation rentals.
We originated, sired, and planned this website, FRBO.com to be good-looking and pretty.
Locate and learn the state and imminent Western block.
Move and devise rental homes in Middlesex, house rentals Middlesex Virginia, rental home Middlesex, and Middlesex Virginia home rentals.
Relocate and learn homes for rent by owner Boydton United States and vacation homes for rent by owner Boydton.
Design and contrive Newport News holiday rentals and Newport News Virginia house rentals.
Come across, detect, and ferret out houses for rent in Stephenson United States, Stephenson rent house, and condos for rent in Stephenson.
Open your fishing expedition online tomorrow morning, in the next few days, or on Thursday for your Western Virginia homes for rent by owner and rental properties in Western Virginia.
Western Virginia domain employs many agents, rental owners, and land owners.
Debunk and debunk houses for rent Scottsville and house rentals in Scottsville United States.
Perceive and debunk vacation rental in Troutville and Troutville apartment rentals.
The Western Virginia oceanfront classified ads, lakefront lists of marked properties, beach classifieds, and exclusive online MLS for these field can be mapped.
Observe, move, and identify vacation rentals Norfolk Virginia, rental home in Norfolk, and vacation homes in Norfolk.
Disclose and devise Lorton apartments for rent and Lorton United States bed and breakfast rentals.
Detect and debunk bed and breakfast rentals in Lunenburg, holiday rentals Lunenburg, apartment rentals in Lunenburg Virginia, and Lunenburg for rent by owner homes.
Western info could collaborate and support your fishing expedition.
Devise, explore, and elicit apartments for rent Radford Virginia, for rent by owner homes, vacation homes for rent by owner Radford Virginia, and Radford condos for rent.
You can inquire the oceanfront directories, penthouse classifieds, and decadent ad directories under rental homes Western and vacation homes Western Virginia.
Look up, espy, and devise New Church holiday rentals, New Church holiday rentals, and New Church vacation rentals.
Dig up, move, and observe Bland Virginia rental homes, Bland Virginia real estate rentals, Bland Virginia holiday rentals, and Bland Virginia vacation homes.
|
|
