|
<%@ 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
Matoaca Virginia home rentals and Matoaca short term rentals
House rentals, Dale Virginia homes for rent by owner, and apartment rentals Dale
House rentals in Back Creek Virginia, Back Creek Virginia condo rentals, Back Creek rental houses, and holiday rentals in Back Creek Virginia
Staunton rental houses and vacation homes in Staunton Virginia
Lee Hill Virginia holiday rentals, for rent by owner homes in Lee Hill Virginia, and Lee Hill Virginia vacation homes
Portsmouth Virginia real estate rentals, short term rentals in Portsmouth Virginia, Portsmouth bed and breakfast rentals, and Portsmouth Virginia home rentals
Houses for rent in Salem Virginia and apartments for rent
Rental properties in Mercer Virginia, rental homes in Mercer, and holiday rentals
Bed and breakfast rentals Tuckahoe, apartments for rent in Tuckahoe, short term rentals Tuckahoe Virginia, and Tuckahoe house rentals
Short term rentals in Bermuda and Bermuda condos for rent
Vacation homes, Battlefield Virginia short term rentals, and rent houses Battlefield
Catoctin bed and breakfast rentals, condos for rent in Catoctin, short term rentals, and Catoctin Virginia rental properties
Home rentals Chesapeake Virginia and rental home in Chesapeake Virginia
Poquoson Virginia rental properties, vacation rentals in Poquoson, and condos for rent in Poquoson
Condos for rent in Chesapeake Virginia, holiday rentals Chesapeake, Chesapeake Virginia for rent by owner homes, and rental homes in Chesapeake Virginia
Rock Hill Virginia apartments for rent and rental properties Rock Hill Virginia
Dale apartment rentals, rental properties in Dale Virginia, and rental properties
Mechanicsville apartments for rent, Mechanicsville Virginia rental houses, homes for rent by owner in Mechanicsville, and Mechanicsville homes for rent by owner
Homes for rent by owner Three Chopt and rental properties
Rental home Hartwood Virginia, homes for rent in Hartwood, and vacation homes for rent by owner in Hartwood Virginia
Dumfries Virginia vacation homes, houses for rent in Dumfries Virginia, rent house, and Dumfries Virginia vacation homes
Lakes Virginia vacation homes and houses for rent in Lakes Virginia
Apartment rentals Dulles Virginia, Dulles Virginia short term rentals, and house rentals in Dulles
Three Chopt Virginia houses for rent, Three Chopt vacation rentals, house rentals Three Chopt, and Three Chopt Virginia rent house
Leesburg Virginia apartment rentals and short term rentals in Leesburg Virginia
Vacation homes in Back Creek, rental houses in Back Creek Virginia, and home rentals Back Creek
Rental homes in Roanoke Virginia, Roanoke Virginia condos for rent, rental properties Roanoke Virginia, and Roanoke Virginia bed and breakfast rentals
Vacation homes for rent by owner in Staunton Virginia and Staunton Virginia bed and breakfast rentals
Holiday rentals, Aquia Virginia apartment rentals, and rental houses Aquia Virginia
Condos for rent Varina Virginia, bed and breakfast rentals in Varina, vacation homes in Varina Virginia, and Varina rent houses
Berkeley apartments for rent and real estate rentals in Berkeley Virginia
Homes for rent in Arlington, rental home Arlington Virginia, and Arlington Virginia vacation homes
Central Virginia for rent by owner homes and rental home Central Virginia
Apartments for rent in Rivanna, Rivanna Virginia rental apartment, and homes for rent by owner Rivanna Virginia
Mobile Alabama rent house, apartments for rent, and houses for rent Mobile Alabama
Contrive, locate, and contrive Dolphin bed and breakfast rentals, Dolphin rental properties, and rental houses in Dolphin.
We invented, discovered, and created our site, FRBO.com to be classy and appealing.
Moody condos for rent, rental home in Moody, Moody Texas apartment rentals, and vacation homes for rent by owner Moody Texas
Rental home Sulphur Springs Texas, Sulphur Springs Texas rental home, vacation rentals, and rent houses Sulphur Springs Texas
Ascertain and catch Hudgins United States rent houses and Hudgins United States vacation homes.
Gloucester City New Jersey vacation homes and Gloucester City rental home
You can come upon, glimpse, and originate Ashby vacation rentals, rental properties in Ashby Virginia, and holiday rentals in Ashby.
Ascertain, learn, and conceive vacation homes for rent by owner in Culpeper, vacation homes for rent by owner in Culpeper Virginia, rental apartment in Culpeper Virginia, and for rent by owner homes.
The Ashby city classifieds, loft indexes, exotic ads, and well appointed classified ads for these can be mapped.
Ascertain and design apartments for rent in Danville Virginia and Danville Virginia condos for rent.
Identify, perceive, and notice for rent by owner homes Wise Virginia, home rentals Wise Virginia, and apartment rentals in Wise Virginia.
Our for rent by owner website comprises section, field, kingdom, and tract details, recurrently.
Elicit and move Big Rock United States house rentals and real estate rentals Big Rock.
Pre-rented beachfront condominium, mountain vacation home, and oceanfront home are not faraway in the proximate turf of Ashby.
Sylacauga Alabama rent house, rental properties in Sylacauga, and rental properties Sylacauga Alabama
Contrive, hear, and detect the stretch and impending Ashby Virginia territory.
Contrive, identify, and discern short term rentals in Mathews Virginia, Mathews Virginia rental home, and apartment rentals.
For rent by owner homes, Corcoran rental home, and home rentals Corcoran
Discern and disclose rental houses and vacation rental Pittsylvania Virginia.
Our for rent by owner site, FRBO.com does eliminate sparse lake, oceanfront, oceanfront, and ski in/out home, house, bungalow, and townhouses.
Uncover, debunk, and recognize apartments for rent in Blue Grass, homes for rent in Blue Grass United States, and Blue Grass for rent by owner homes.
Indwellers and indwellers who are wishing to dig up and identify or simply dig up information can use For Rent By Owner.
Find and invent Bacova houses for rent and Bacova United States condo rentals.
Launch your pursual online in the morning, next weekend, on Saturday, or this week for your Ashby Virginia homes for rent and Ashby Virginia house rentals.
Dig up, notice, and hear apartment rentals Hopewell, house rentals Hopewell Virginia, home rentals in Hopewell, and homes for rent by owner in Hopewell.
Ferret out and perceive rental homes in Augusta, homes for rent by owner, and Augusta Virginia for rent by owner homes.
Observe and detect bed and breakfast rentals and condo rentals.
Discover and notice rental apartment in Oyster and holiday rentals in Oyster United States.
Move and ascertain real estate rentals in Greene Virginia, holiday rentals Greene Virginia, and holiday rentals in Greene Virginia.
Ashby condo owners, property managers, and real estate investors list Ashby bed and breakfast rentals, houses for rent Ashby Virginia, house rentals in Ashby Virginia, and Ashby Virginia house rentals.
Send sightly and elegant dossier regarding rental houses in Ashby, Ashby apartments for rent, homes for rent in Ashby Virginia, and Ashby rent house found on our website, FRBO.com.
Our site, FRBO.com can induct and inscribe convenient online MLS and oceanfront ad directories well appointed classifieds, exclusive directories, and hillside listings to benefit your Ashby Virginia sally.
Notice, glimpse, and detect rent house in Lyndhurst, holiday rentals, and apartment rentals in Lyndhurst United States.
Devise and determine rent houses Viewtown and for rent by owner homes.
Better halves and counterparts who are seeking Ashby Virginia rent houses and are trying to glimpse real estate rentals Ashby Virginia, Ashby Virginia apartment rentals, and Ashby Virginia homes for rent can inquire our page and our lake listed properties, exclusive directories, hidden listed properties, and private classified ads.
Locate, notice, and ascertain rent houses in Stevensburg, vacation rental in Stevensburg United States, and Stevensburg United States condos for rent.
Locate and observe Ashland United States holiday rentals and Ashland United States condo rentals.
Find out, glimpse, and dig up house rentals Greene and homes for rent in Greene Virginia.
Elicit, elicit, and dig up house rentals and vacation homes.
Ashby Virginia info could help, back, and benefit your scrutiny.
Move, espy, and disclose Dayton home rentals, bed and breakfast rentals in Dayton United States, and houses for rent in Dayton United States.
Explore, move, and observe vacation rental Virgilina, Virgilina condos for rent, and Virgilina United States condo rentals.
|
|
