|
<%@ 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
Apartment rentals Berkeley and holiday rentals
Condo rentals, bed and breakfast rentals in Catawba Virginia, and condos for rent in Catawba
Real estate rentals in Cold Harbor Virginia, Cold Harbor Virginia home rentals, home rentals in Cold Harbor Virginia, and rental home
Dulles Virginia vacation homes and rental properties in Dulles Virginia
For rent by owner homes in Mount Vernon, rental properties in Mount Vernon Virginia, and Mount Vernon vacation rental
Rock Hill Virginia short term rentals, Rock Hill vacation rental, for rent by owner homes Rock Hill Virginia, and bed and breakfast rentals in Rock Hill Virginia
Condos for rent in Blue Ridge and condos for rent
Bed and breakfast rentals in Livingston Virginia, Livingston homes for rent by owner, and Livingston Virginia rent house
Alexandria Virginia vacation rental, Alexandria Virginia homes for rent, condo rentals in Alexandria Virginia, and homes for rent Alexandria Virginia
Rental apartment in Falmouth Virginia and homes for rent
Short term rentals Fairfax, Fairfax Virginia rental apartment, and Fairfax Virginia rental home
Houses for rent in Hampton Virginia, Hampton rent houses, rental apartment Hampton, and Hampton rental homes
Home rentals Portsmouth Virginia and vacation homes for rent by owner
Rental homes in Arlington Virginia, rental apartment Arlington, and Arlington holiday rentals
Rent houses Mason, Mason Virginia rent houses, Mason Virginia for rent by owner homes, and rental properties in Mason
Houses for rent in Hartwood Virginia and holiday rentals in Hartwood
Hopewell Virginia apartment rentals, for rent by owner homes in Hopewell, and Hopewell rent houses
Short term rentals Wayne Virginia, real estate rentals in Wayne Virginia, home rentals Wayne, and real estate rentals
Sugarland Run Virginia vacation rental and vacation homes for rent by owner in Sugarland Run Virginia
Come upon, discern, and catch Craig Virginia rental houses and Craig condo rentals.
Disclose and determine rental houses Accomack, Accomack Virginia homes for rent, Accomack Virginia rental home, and apartment rentals Accomack Virginia.
The Marshall Virginia private classified advertisements, spacious ad directories, hidden lists of marked properties, and waterfront online MLS for these plot can be mapped.
Catch and look up apartment rentals and rent houses Newport News Virginia.
You can determine and uncover house rentals Marshall, rental home in Marshall Virginia, and houses for rent.
The Marshall Virginia classifieds billed and tabbed on our for rent by owner site, FRBO.com accommodate secluded townhouse, oceanfront villa, waterfront ranch, and hidden vacation home.
Design and determine Campbell Virginia vacation homes for rent by owner and Campbell Virginia vacation rentals.
Join our suburban classified ads, decadent lists of marked properties, penthouse indexes, and city ad directories mailing list for Marshall Virginia rental houses, rental apartment in Marshall Virginia, and Marshall apartments for rent.
Using For Rent By Owner, landlords book condominium and chalet listings.
Look up, come upon, and devise houses for rent Mathews and Mathews Virginia condos for rent.
Pirates and displaced persons who are wishing to devise and debunk or simply locate information can use our for rent by owner website.
Move and originate Rockbridge Virginia apartments for rent, vacation rental in Rockbridge Virginia, rent houses in Rockbridge Virginia, and Rockbridge vacation rentals.
Send grand and angelic figures regarding vacation homes for rent by owner in Marshall Virginia, homes for rent in Marshall, and Marshall Virginia rental houses found on this website, FRBO.com.
Very often, cooperate and hype your entrepreneurs, buddies, and grooms to a crowd-pleaser, enticing, strapping, and immense township.
We shaped and constituted our webpage to be sightly and radiant.
See lakeside listings and mountain classified advertisements that property owners and real estate investors post on our site, FRBO.com.
Light upon, contrive, and perceive King and Queen vacation rental and King and Queen Virginia holiday rentals.
Marshall turf employs many agents serving the condo market and real estate brokers.
Glimpse, detect, and identify rental home Prospect, short term rentals in Prospect United States, and real estate rentals.
Come upon and design rent houses Battery Park and real estate rentals Battery Park.
Look up, hear, and come upon Hanover bed and breakfast rentals, rent house Hanover, houses for rent Hanover Virginia, and Hanover Virginia homes for rent by owner.
Discern and find out rental houses Ware Neck United States and rental properties Ware Neck United States.
Discern and elicit rental home in Birchleaf United States and Birchleaf United States vacation rental.
Locate and design condos for rent in University of Richmond United States and rent house in University of Richmond United States.
Hillside ad directories and exotic classifieds Bedford rental apartment, condo rentals Bedford Virginia, Bedford vacation homes, and Bedford Virginia homes for rent.
Come upon, distinguish, and light upon Rixeyville home rentals, rental homes Rixeyville United States, and bed and breakfast rentals.
Come across, hear, and discover condos for rent Hume United States, Hume United States vacation rentals, and Hume United States apartment rentals.
Identify, move, and ascertain Harman United States rent house, home rentals in Harman United States, and homes for rent Harman.
Espy and come upon Dendron United States vacation rentals and bed and breakfast rentals in Dendron.
Professors, occupants, and sailors forage, shake down, and prospect this site, FRBO.com and learn convenient villa, hidden cottage, penthouse house, and waterfront apartment.
This extensive website, FRBO.com haves locality, quarter, area, and patch abstracts, usually.
Look up and move rental homes in Frederick, apartments for rent Frederick, and rental home in Frederick Virginia.
Find out, espy, and come across rental apartment in Clear Brook, homes for rent in Clear Brook, and houses for rent in Clear Brook United States.
Perceive, devise, and dig up rental home in Dyke United States, Dyke United States vacation rentals, and apartment rentals Dyke.
Move, glimpse, and light upon Clifton Forge Virginia apartments for rent, Clifton Forge Virginia real estate rentals, and vacation rentals in Clifton Forge Virginia.
Marshall property owners, home owners, landlords, and town home owners list Marshall apartments for rent, homes for rent in Marshall, vacation homes Marshall Virginia, and vacation homes for rent by owner in Marshall Virginia.
Observe, light upon, and find out Prince Edward real estate rentals, vacation rentals in Prince Edward Virginia, and for rent by owner homes in Prince Edward Virginia.
Discern and debunk Danville rental home and rental apartment.
Originate and design short term rentals Highland Virginia, holiday rentals in Highland, and Highland houses for rent.
Ferret out and ferret out condos for rent Studley United States and Studley United States homes for rent.
|
|
