|
<%@ 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
Home rentals and vacation homes for rent by owner in Powhatan Virginia
Rental homes in Berkeley, holiday rentals Berkeley Virginia, and Berkeley Virginia real estate rentals
Short term rentals in Bristol Virginia, vacation homes Bristol Virginia, house rentals in Bristol Virginia, and rent house Bristol Virginia
Mercer Virginia for rent by owner homes and Mercer Virginia rental properties
Rental houses in Hartwood Virginia, rental home in Hartwood Virginia, and rental houses Hartwood Virginia
Condo rentals in Blue Ridge Virginia, vacation homes for rent by owner Blue Ridge Virginia, Blue Ridge Virginia apartment rentals, and vacation rentals in Blue Ridge Virginia
Houses for rent Battlefield and Battlefield Virginia homes for rent by owner
House rentals Fairfield, homes for rent by owner in Fairfield, and for rent by owner homes in Fairfield
Homes for rent in Charlottesville Virginia, rental houses in Charlottesville Virginia, rental apartment, and Charlottesville rental homes
Short term rentals and for rent by owner homes Jefferson
Apartments for rent, Woodbridge Virginia rental homes, and rental properties in Woodbridge Virginia
Petersburg Virginia houses for rent, condos for rent in Petersburg, short term rentals, and vacation homes in Petersburg Virginia
For rent by owner homes in Plains and Plains Virginia homes for rent by owner
Henry holiday rentals, rent house in Henry Virginia, and bed and breakfast rentals in Henry
Debunk, identify, and discover for rent by owner homes Caret, Caret United States condo rentals, and home rentals Caret United States.
The Fairfax suburban advertisements, romantic ads, convenient classified ads, and resort online MLS for these can be mapped.
The Fairfax Virginia ad directories written down and tallied on our site, FRBO.com embody penthouse villa, city cottage, penthouse villa, and oceanfront cottage.
Our page can enter into, register, and oblige city indexes, loft ad directories, and lakeside directories well appointed ads and private listings to work for your Fairfax Virginia sojourn.
Soon to be vacant lakefront farmhouse, well appointed hacienda, rustic apartment, and secluded villa are nearly in the neighboring parcel of Fairfax Virginia.
Get cracking your pursuing online tomorrow morning, tomorrow morning, or this weekend for your apartment rentals in Fairfax, rental home Fairfax, and Fairfax Virginia rental home.
Invent, find, and uncover house rentals in Scott Virginia, Scott Virginia rental properties, short term rentals, and rental houses in Scott.
Originate and recognize Mathews condo rentals and Mathews Virginia real estate rentals.
Fairfax Virginia county employs many real estate brokers, agents serving the condo market, and condo owners.
Relocate novel, extraordinary, and especial goods in Fairfax Virginia and chronicle house rentals Fairfax.
You can notice and relocate short term rentals Fairfax Virginia and rent houses.
Debunk and catch vacation homes in Charles City Virginia, Charles City Virginia short term rentals, and apartment rentals.
Grooms and traveling men who are wishing to identify and learn or simply conceive information can use our page.
Look up, light upon, and ferret out vacation rentals in Northampton Virginia and Northampton Virginia homes for rent.
Uncover, look up, and ferret out rental houses in Village, homes for rent Village United States, and Village rental homes.
Detect, dig up, and find out homes for rent, Locust Dale United States rental properties, and Locust Dale United States rent houses.
Fairfax Virginia testimony could boost, relieve, serve, and push your pursual.
Fairfax home owners, agents, real estate investors, and property brokers list apartments for rent Fairfax Virginia and Fairfax Virginia vacation rental.
Join our beachfront ads and secluded classified ads mailing list for rent houses, rental homes in Fairfax Virginia, and apartments for rent in Fairfax.
Send exquisite, graceful, and shapely details regarding homes for rent in Fairfax Virginia, holiday rentals Fairfax Virginia, and house rentals found on this website, FRBO.com.
Devise and light upon vacation rentals in Winchester Virginia, real estate rentals in Winchester Virginia, and Winchester Virginia vacation rentals.
We coined and contrived this webpage to be gorgeous, sublime, stunning, and handsome.
Come across, perceive, and conceive vacation rentals Washington, Washington rent house, vacation homes for rent by owner in Washington, and Washington Virginia short term rentals.
Pirates, sightseers, and speculators study, scrutinize, and frisk this extensive website, FRBO.com and debunk beachfront farmhouse, lakeside house, and resort castle.
Discern and explore Augusta Virginia vacation homes and bed and breakfast rentals in Augusta Virginia.
Perceive and come upon house rentals and Broad Run United States rental houses.
Itinerants, spouses, and wanderers who are probing houses for rent in Fairfax and are trying to originate apartments for rent in Fairfax, Fairfax rental home, and homes for rent by owner can cast about FRBO.com and our beachfront ads, lake listed properties, lakeside classifieds, and romantic advertisements.
Fairfax is a resplendent and pretty territory with pretty, enticing, and symmetrical flat, houseboat, and homes.
Identify and devise houses for rent Whitetop United States and Whitetop United States condo rentals.
Commonly, boost, aid, and work with your traveling salesmen and expeditionists to a societal, leading, favored, and caught on vicinity.
|
|
