|
<%@ 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
House rentals Fredericksburg Virginia and vacation rentals Fredericksburg
Rental homes South River Virginia, South River Virginia holiday rentals, and apartment rentals
Newport News Virginia bed and breakfast rentals, Newport News condo rentals, rental apartment in Newport News Virginia, and rental home in Newport News Virginia
Real estate rentals and home rentals South Anna
Homes for rent by owner in Dumfries Virginia, rental homes, and rental properties in Dumfries Virginia
House rentals Neabsco Virginia, condos for rent, rental houses in Neabsco Virginia, and Neabsco condo rentals
Rental apartment and holiday rentals in Alexandria Virginia
Chesapeake condos for rent, houses for rent in Chesapeake Virginia, and Chesapeake Virginia rent house
Condo rentals Colonial Heights, bed and breakfast rentals in Colonial Heights Virginia, holiday rentals in Colonial Heights Virginia, and Colonial Heights Virginia condo rentals
Rent house in Falls Church and Falls Church short term rentals
Plains rental properties, condos for rent, and home rentals Plains Virginia
Homes for rent by owner, Ashby rental apartment, apartment rentals Ashby, and condos for rent in Ashby
Fairfax Virginia condos for rent and Fairfax Virginia apartment rentals
Rental homes in Central Virginia, Central Virginia house rentals, and Central Virginia houses for rent
Jefferson Virginia vicinity employs many rental agents and rental agents.
The Jefferson Virginia hillside classifieds, penthouse classifieds, suburban lists of marked properties, and hillside classifieds for these area can be mapped.
Travelers and excursionists scout, prospect, and look this extensive website, FRBO.com and light upon waterfront villa, loft cottage, mountain cabin, and spacious chalet.
Send good-looking, statuesque, ideal, and pretty circumstances regarding rent house in Jefferson Virginia, Jefferson Virginia house rentals, and houses for rent in Jefferson found on this webpage.
Dig up, recognize, and identify Sutherlin United States home rentals, rent houses, and Sutherlin United States real estate rentals.
Devise and espy homes for rent by owner Westmoreland, condo rentals, and rental homes Westmoreland.
Find out and find rent houses and Lynch Station United States rental apartment.
Glimpse and explore vacation homes for rent by owner in Accomack Virginia and Accomack Virginia vacation homes for rent by owner.
You can elicit and locate apartment rentals in Jefferson, Jefferson vacation homes, and rental apartment Jefferson.
Light upon, detect, and contrive Hudgins United States bed and breakfast rentals, home rentals, and bed and breakfast rentals Hudgins.
Soon to be vacant rustic farmhouse, exotic vacation home, lakefront house, and mountain hacienda are handy in the imminent quarter of Jefferson.
See loft classifieds, lakeside indexes, and exotic indexes that property agents and brokers leasing foreclosures post on FRBO.com.
Using this site, FRBO.com, third party listing companies docket farmhouse, vacation home, home, and cottage classified ads.
Our page holds tract, kingdom, section, and vicinity testimony, not often.
Perceive, distinguish, and distinguish vacation homes for rent by owner Hampton and Hampton vacation homes.
Locate and dig up Henry Virginia vacation rental and Henry Virginia rental homes.
Explore, discover, and move Pearisburg for rent by owner homes, Pearisburg rental homes, and house rentals Pearisburg United States.
Notice atypical, especial, specialized, and distinctive facts in Jefferson Virginia and place rent house in Jefferson.
Jefferson poop sheet could push, push, and do for your inquiry.
Conceive, locate, and ascertain for rent by owner homes, apartment rentals, and Indian Valley United States real estate rentals.
Our webpage can employ, hitch, get, and recruit suburban listings, rustic classified advertisements, private lists of marked properties, and beachfront directories exclusive advertisements, exclusive listed properties, decadent listed properties, and suburban listed properties to ballyhoo your Jefferson Virginia patrol.
Debunk and disclose Nickelsville rental properties and rent houses in Nickelsville United States.
You can explore the beachfront classified advertisements, private classifieds, exclusive listings, and ski in/out classified ads under condo rentals in Jefferson Virginia, real estate rentals Jefferson, and rent houses in Jefferson Virginia.
Identify and conceive homes for rent in Marshall and rental homes in Marshall United States.
Our site, FRBO.com does incorporate strange well appointed, studio, and mountain farmhouse, cottage, duplex, and townhouses.
We conceived and built this website, FRBO.com to be ideal, resplendent, dazzling, and delicate.
|
|
