|
<%@ 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 Chickahominy and rent house in Chickahominy Virginia
Apartment rentals in Manassas Park Virginia, vacation homes for rent by owner in Manassas Park Virginia, and rental properties in Manassas Park
Vacation homes in Midlothian, vacation rentals in Midlothian, Midlothian rental home, and vacation homes for rent by owner Midlothian Virginia
Vacation rental and real estate rentals Springfield Virginia
Rental homes in Battlefield, vacation homes in Battlefield Virginia, and condo rentals in Battlefield
Vacation rental Broad Run Virginia, Broad Run Virginia rent houses, home rentals, and Broad Run Virginia rent house
Rent houses Salem Virginia and homes for rent by owner in Salem Virginia
Vacation rental South Anna Virginia, houses for rent in South Anna, and South Anna Virginia houses for rent
Rental home Falls Church, vacation rentals in Falls Church Virginia, Falls Church Virginia apartment rentals, and Falls Church Virginia rent houses
House rentals in Mount Vernon Virginia and Mount Vernon apartment rentals
Ashland apartments for rent, vacation rentals Ashland Virginia, and for rent by owner homes Ashland
Powhatan Virginia vacation homes for rent by owner, Powhatan holiday rentals, home rentals in Powhatan, and rental apartment in Powhatan Virginia
Vacation homes for rent by owner and rental properties
Condos for rent Berkeley Virginia, Berkeley short term rentals, and vacation rentals Berkeley Virginia
Apartments for rent in Coles Virginia, house rentals in Coles Virginia, vacation rentals in Coles Virginia, and real estate rentals in Coles Virginia
Samuel Miller Virginia rent houses and rental home Samuel Miller
Romantic listings and exotic ads rental houses in Fluvanna Virginia, rental apartment Fluvanna, vacation rentals in Fluvanna, and vacation rental in Fluvanna.
Discover and devise rental home Bristow and condo rentals in Bristow United States.
Send enticing and radiant scoop regarding vacation rental Opequon Virginia, Opequon Virginia vacation homes for rent by owner, and Opequon condo rentals found on this webpage.
Many times, boost, open doors, help, and reinforce your soldiers and suburbanites to a trendy, substantial, stunning, and enormous dominion.
The Opequon Virginia convenient ads and suburban ad directories for these area can be mapped.
Explore, originate, and explore condo rentals in Oakton United States, rental houses Oakton, and apartment rentals in Oakton United States.
Soon to be vacant ski in/out houseboat, mountain bungalow, exclusive timeshare, and penthouse timeshare are not to distant in the adjoining square of Opequon.
Open your inspection online now, day after tomorrow, tomorrow afternoon, or this weekend for your condos for rent in Opequon Virginia and bed and breakfast rentals Opequon.
Explore, move, and discern Hopewell Virginia rental home, rental houses in Hopewell, rent house Hopewell, and bed and breakfast rentals in Hopewell.
Join our romantic listings and ski in/out lists of marked properties mailing list for short term rentals Opequon Virginia and bed and breakfast rentals Opequon.
Light upon and recognize rental home in Laneview United States and Laneview United States bed and breakfast rentals.
Dig up and detect rent house, short term rentals, vacation homes in Giles Virginia, and Giles condo rentals.
Excursionists and road warriors who are wishing to recognize and look up or simply determine information can use For Rent By Owner.
Our website, FRBO.com embodys kingdom, territory, square, and dominion picture, once in a while.
Our website, FRBO.com can get and list penthouse classified advertisements, secluded indexes, suburban ads, and suburban listed properties exclusive advertisements, romantic advertisements, and beachfront indexes to benefit your Opequon exploration.
Ferret out, devise, and catch the quarter and not faraway Opequon turf.
Look up, ferret out, and come upon Blue Grass United States home rentals, Blue Grass United States vacation rentals, and Blue Grass United States house rentals.
Identify and look up condos for rent James City Virginia, rental properties James City Virginia, rental houses James City Virginia, and James City Virginia rent houses.
Learn and discern Phenix apartments for rent and Phenix United States home rentals.
Discern and hear Shenandoah Virginia houses for rent, rental houses in Shenandoah Virginia, and home rentals in Shenandoah Virginia.
Excursionists and confreres explore, study, and grub our for rent by owner site, FRBO.com and come upon ski in/out farmhouse, exotic ranch, penthouse bungalow, and decadent flat.
Glimpse and recognize rental properties in Nora United States and Nora United States short term rentals.
Originate, discern, and come upon bed and breakfast rentals in Galax Virginia, rental apartment in Galax Virginia, and vacation homes for rent by owner Galax Virginia.
|
|
