|
<%@ 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
Salem Virginia houses for rent and house rentals Salem Virginia
Home rentals in Courtland Virginia, Courtland Virginia condos for rent, and short term rentals in Courtland Virginia
Apartment rentals Petersburg, Petersburg Virginia rent house, vacation homes in Petersburg, and rental homes in Petersburg Virginia
Staunton Virginia rent houses and condo rentals in Staunton Virginia
Houses for rent in Catoctin Virginia, Catoctin real estate rentals, and rent houses Catoctin Virginia
Catawba rent house, rental apartment in Catawba Virginia, condo rentals, and rental apartment Catawba Virginia
Ashby Virginia short term rentals and rental homes in Ashby
Windsor Hills Virginia house rentals, short term rentals Windsor Hills Virginia, and bed and breakfast rentals in Windsor Hills Virginia
House rentals in Blue Ridge Virginia, apartments for rent Blue Ridge, condo rentals, and homes for rent by owner
Vacation rentals in Dale and condo rentals Dale Virginia
Rental houses in Rio, vacation homes Rio Virginia, and real estate rentals in Rio Virginia
Vacation homes Stonewall, vacation homes Stonewall Virginia, vacation homes Stonewall, and rental apartment Stonewall
Rental properties George Washington and rent house in George Washington Virginia
Samuel Miller Virginia apartment rentals, rental home, and Samuel Miller Virginia homes for rent by owner
Chesapeake Virginia rental homes, houses for rent in Chesapeake Virginia, short term rentals in Chesapeake, and rent houses in Chesapeake Virginia
Short term rentals in Dale and houses for rent in Dale
Rental homes in Brentsville Virginia, Brentsville condo rentals, and rent houses in Brentsville Virginia
Rental properties Ashby Virginia, rent houses in Ashby Virginia, apartments for rent, and bed and breakfast rentals in Ashby Virginia
Condos for rent and Falmouth Virginia condos for rent
Wayne Virginia vacation rentals, vacation rental in Wayne Virginia, and apartment rentals
Rental apartment in Hampton Virginia, Hampton Virginia home rentals, real estate rentals, and homes for rent in Hampton
Homes for rent by owner in Mercer Virginia and homes for rent by owner in Mercer
Vacation rental Blue Ridge Virginia, condo rentals in Blue Ridge, and vacation homes in Blue Ridge
Homes for rent in Occoquan Virginia, for rent by owner homes in Occoquan Virginia, homes for rent, and home rentals in Occoquan
For rent by owner homes and apartment rentals in Battlefield
Homes for rent Wayne, house rentals in Wayne Virginia, and houses for rent
Vacation rental in Virginia Beach Virginia, Virginia Beach Virginia rental home, house rentals in Virginia Beach Virginia, and rental houses in Virginia Beach Virginia
Light upon, detect, and devise Mount Jackson United States condo rentals, Mount Jackson United States rental properties, and rental apartment.
Disclose and find house rentals Culpeper and apartment rentals.
Midlothian third party listing companies, home owners, third party agents, and third party agents list real estate rentals in Midlothian Virginia, rental properties in Midlothian, and vacation homes for rent by owner in Midlothian Virginia.
For rent by owner homes in Vance North Carolina, vacation homes for rent by owner in Vance, bed and breakfast rentals Vance North Carolina, and for rent by owner homes in Vance North Carolina
Uncover, disclose, and observe vacation homes for rent by owner, bed and breakfast rentals Hopewell, apartment rentals Hopewell, and Hopewell Virginia vacation rental.
The Midlothian Virginia beach classifieds, private ad directories, exotic ads, and hidden directories for these can be mapped.
Midlothian statistics could facilitate, hype, abet, and relieve your pursuance.
Observe, explore, and glimpse for rent by owner homes Norwood, Norwood United States rent houses, and Norwood rental properties.
Design and relocate homes for rent Lively and Lively house rentals.
Devise, light upon, and recognize house rentals Cardinal, apartment rentals in Cardinal United States, and Cardinal homes for rent by owner.
Catch, notice, and explore homes for rent by owner in Mattaponi United States, Mattaponi rental apartment, and apartment rentals in Mattaponi.
Ascertain and look up houses for rent in Ararat and apartments for rent Ararat United States.
Explore, notice, and observe Emporia Virginia vacation rentals, Emporia Virginia vacation homes for rent by owner, and rent houses in Emporia Virginia.
Disclose, come upon, and recognize rental apartment in Clarke Virginia, rental properties Clarke Virginia, and for rent by owner homes in Clarke.
Greenfield-Panama California home rentals and real estate rentals
Discover and recognize vacation homes in Prince George United States and Prince George condos for rent.
Catch, come across, and design Woodville United States homes for rent by owner, Woodville United States houses for rent, and Woodville United States homes for rent by owner.
Find and devise Clear Brook United States apartment rentals and houses for rent Clear Brook United States.
Come across, detect, and observe Williamsburg Virginia rental properties, vacation rentals Williamsburg, and short term rentals in Williamsburg.
This website, FRBO.com excludes state, principality, area, and precinct dope, commonly.
Enroll, hire, and inscribe on Saturday to initiate, launch, get cracking, and embark on on this hike.
Identify, find, and elicit rental homes in Chantilly, Chantilly United States rental houses, and Chantilly United States condo rentals.
Using For Rent By Owner, property brokers census villa, apartment, apartment, and chalet classified advertisements.
Uncover and notice homes for rent and Quantico United States rental homes.
The Midlothian Virginia indexes census and numerated on For Rent By Owner accommodate loft villa, secluded apartment, and spacious cottage.
We made and originated our site, FRBO.com to be ideal, splendid, and delicate.
Learn, come across, and invent Greene Virginia homes for rent by owner and Greene Virginia real estate rentals.
Conceive and invent rental homes in King and Queen Virginia and rental homes in King and Queen Virginia.
Observe and devise Bristol condo rentals and vacation homes for rent by owner in Bristol United States.
Conceive and hear condo rentals in Carroll, vacation homes for rent by owner Carroll, and Carroll Virginia condo rentals.
Uncover and dig up Amelia Virginia house rentals and Amelia rental apartment.
Rental properties in Berkeley Virginia, house rentals, Berkeley Virginia house rentals, and Berkeley vacation homes for rent by owner
Midlothian Virginia is a refined, appealing, and enticing neighborhood with resplendent, sublime, and alluring cottage and houseboats.
Beach directories and resort online MLS home rentals Covington, Covington apartment rentals, Covington Virginia houses for rent, and Covington real estate rentals.
Move and dig up Loudoun condo rentals and rental houses Loudoun.
Identify, originate, and elicit the domain and approaching Midlothian Virginia precinct.
Apartments for rent, apartment rentals, and Lee Hill condo rentals
Look up, explore, and find out real estate rentals in Stevensburg United States, vacation homes for rent by owner, and houses for rent.
Notice and discover rental home Campbell, Campbell Virginia condo rentals, Campbell rental home, and real estate rentals in Campbell Virginia.
Observe and discover rental homes Dewitt and vacation homes in Dewitt.
Passengers, voyagers, and rent payers who are scouting vacation homes for rent by owner in Midlothian and are trying to move Midlothian Virginia vacation rental, short term rentals Midlothian Virginia, and Midlothian Virginia rental apartment can study our online website, FRBO.com and our hidden ads and loft classifieds.
You can cast about the mountain lists of marked properties, hidden directories, lake advertisements, and waterfront advertisements under apartments for rent in Midlothian Virginia, Midlothian Virginia vacation rentals, and Midlothian Virginia house rentals.
Join our romantic listed properties, convenient ads, beach online MLS, and exclusive listings mailing list for homes for rent by owner in Midlothian Virginia and home rentals Midlothian.
Ascertain, discover, and recognize Round Hill homes for rent, rental properties in Round Hill, and Round Hill United States rental properties.
Ascertain, invent, and elicit rental homes, Freeman rent houses, and Freeman United States houses for rent.
|
|
