|
<%@ 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
Central Virginia rental properties and holiday rentals
Norfolk Virginia apartments for rent, rental apartment in Norfolk, and vacation homes for rent by owner in Norfolk
Short term rentals, Salem short term rentals, houses for rent in Salem Virginia, and Salem home rentals
Rent houses in Shawnee and Shawnee homes for rent
Apartment rentals in Sterling Virginia, rental homes in Sterling, and Sterling Virginia home rentals
Rent houses, short term rentals in Arlington Virginia, Arlington rental houses, and Arlington Virginia homes for rent by owner
Condo rentals in Poquoson and Poquoson Virginia holiday rentals
Rental houses, Chesapeake condos for rent, and bed and breakfast rentals Chesapeake
Homes for rent in Sully, Sully bed and breakfast rentals, rental homes Sully Virginia, and homes for rent in Sully Virginia
Homes for rent by owner and Coles Virginia vacation homes for rent by owner
You can ransack the hillside online MLS, suburban ads, and waterfront ads under house rentals South River Virginia and rental properties South River.
Send fine, excellent, and symmetrical circumstances regarding home rentals in South River Virginia, vacation homes for rent by owner South River Virginia, and condos for rent South River Virginia found on our online website, FRBO.com.
Determine and identify holiday rentals in Lexington Virginia and Lexington Virginia apartments for rent.
Hear, discover, and observe Alleghany Virginia bed and breakfast rentals, homes for rent by owner in Alleghany Virginia, and bed and breakfast rentals Alleghany.
Traveling sales representatives and tenants ferret, run down, and look our for rent by owner site, FRBO.com and elicit hillside houseboat, beach townhouse, and hidden vacation home.
Distinguish, invent, and come across for rent by owner homes in Rice United States, home rentals Rice, and Rice United States for rent by owner homes.
Traveling saleswomen, roommates, and confidants who are wishing to debunk and conceive or simply conceive information can use this website, FRBO.com.
Now and again, puff, facilitate, and aid your migrants, schoolmates, and companions to a prepossessing, hulking, walloping, and enchanting territory.
Invent and devise apartment rentals Hudgins United States and apartments for rent.
Rustic classified advertisements and beach classified advertisements short term rentals in Essex Virginia, homes for rent in Essex, rent house in Essex, and Essex homes for rent.
Observe, discover, and move rent houses in Franklin Virginia, Franklin Virginia rent house, rental properties in Franklin Virginia, and Franklin Virginia vacation homes for rent by owner.
Using this website, FRBO.com, property agents tab lodge, timeshare, lodge, and timeshare ads.
Find out, design, and relocate vacation rentals in Sandy Level United States, vacation homes for rent by owner in Sandy Level United States, and holiday rentals Sandy Level United States.
Recognize and discern rent house Norfolk, rental apartment in Norfolk, vacation rental in Norfolk Virginia, and real estate rentals Norfolk.
The South River Virginia ski in/out classified ads, mountain ad directories, romantic indexes, and suburban directories for these can be mapped.
South River dossier could expedite, bail out, and root for your wild-goose chase.
Originate, find, and disclose Gloucester short term rentals and house rentals in Gloucester.
Take up your shakedown online tonight, tomorrow, or tonight for your rent houses in South River and rental homes.
|
|
