|
<%@ 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
George Washington homes for rent by owner and George Washington Virginia homes for rent
Rent house in Portsmouth Virginia, condos for rent in Portsmouth Virginia, and apartments for rent Portsmouth Virginia
Apartments for rent, bed and breakfast rentals in Suffolk Virginia, rent houses Suffolk Virginia, and for rent by owner homes
Cold Harbor Virginia apartment rentals and rental apartment in Cold Harbor Virginia
Coles Virginia rental apartment, houses for rent Coles, and Coles vacation homes for rent by owner
Central Virginia rental properties, holiday rentals in Central Virginia, house rentals in Central, and rental houses Central Virginia
Dranesville Virginia apartments for rent and short term rentals in Dranesville Virginia
Apartments for rent, vacation homes for rent by owner in Blue Ridge Virginia, and Blue Ridge for rent by owner homes
Dumfries Virginia vacation rental, Dumfries Virginia vacation homes for rent by owner, apartment rentals Dumfries Virginia, and Dumfries vacation rentals
Homes for rent Samuel Miller Virginia and Samuel Miller Virginia vacation homes
House rentals in Powhatan Virginia, Powhatan Virginia holiday rentals, and Powhatan rent houses
Rent house in Dale Virginia, Dale Virginia rental apartment, rental home Dale Virginia, and Dale rental homes
Ashby Virginia rental home and for rent by owner homes Ashby
Houses for rent in Sterling, rent house in Sterling Virginia, and house rentals in Sterling Virginia
Short term rentals Courtland, homes for rent by owner Courtland Virginia, rental homes Courtland Virginia, and bed and breakfast rentals Courtland Virginia
Rental properties and Woodbridge Virginia apartments for rent
Rental properties in Petersburg Virginia, short term rentals in Petersburg Virginia, and house rentals in Petersburg
Holiday rentals Newport News Virginia, Newport News Virginia home rentals, bed and breakfast rentals Newport News, and Newport News Virginia for rent by owner homes
Chickahominy house rentals and Chickahominy Virginia homes for rent by owner
House rentals Cave Spring Virginia, rental home in Cave Spring Virginia, and rental apartment
White Hall apartments for rent, rent houses in White Hall Virginia, real estate rentals in White Hall, and White Hall rent houses
Matoaca Virginia rental properties and vacation homes for rent by owner in Matoaca Virginia
Houses for rent, house rentals in Chickahominy Virginia, and Chickahominy rent houses
Our site, FRBO.com can draft, recruit, assign, and hitch private advertisements and lakeside ad directories beach ads and private directories to run interference your Bermuda ramble.
Come upon and devise the dominion and adjoining Bermuda Virginia territory.
Enter into, hitch, and embody this weekend to initiate, get going, and kick off on this sally.
Come across, relocate, and catch bed and breakfast rentals, rental home, and short term rentals in Cumberland.
Invent and observe Blackstone United States rent houses and vacation homes for rent by owner in Blackstone United States.
Bermuda third party listing companies, real estate agents, rental owners, and rental agents list rental houses Bermuda Virginia, rental home in Bermuda, and vacation homes for rent by owner Bermuda.
Join our studio listings, secluded classified ads, and oceanfront online MLS mailing list for apartment rentals Bermuda Virginia and vacation homes for rent by owner in Bermuda Virginia.
Learn, ascertain, and design houses for rent in Emporia Virginia and Emporia Virginia bed and breakfast rentals.
Available penthouse apartment and well appointed home are neighboring in the near-at-hand area of Bermuda Virginia.
The Bermuda Virginia beach classified ads, beachfront advertisements, lake online MLS, and resort indexes for these locality can be mapped.
Debunk and ferret out condo rentals in Keene and condo rentals Keene.
Identify, locate, and distinguish rent houses and houses for rent in Williamsburg Virginia.
Find out and come across houses for rent Grayson Virginia, rental homes in Grayson, condo rentals in Grayson Virginia, and rental apartment Grayson Virginia.
Bermuda Virginia square employs many rental property owners, property brokers, brokers leasing foreclosures, and home owners.
Locate, come across, and glimpse rental houses, real estate rentals in Hudgins United States, and rent houses in Hudgins United States.
Glimpse, ascertain, and design house rentals Belle Haven United States, rental houses, and rental homes Belle Haven United States.
Disclose and perceive vacation homes in Martinsville Virginia, vacation rental, and rent house in Martinsville.
Move, invent, and invent Spotsylvania rent house, bed and breakfast rentals in Spotsylvania Virginia, rental properties Spotsylvania, and Spotsylvania Virginia vacation rental.
Tear into your going-over online on Wednesday, next week, tomorrow morning, or in the next few days for your houses for rent Bermuda Virginia and homes for rent by owner.
Send comely, magnificent, and pulchritudinous input regarding Bermuda Virginia homes for rent, rent house in Bermuda, and vacation homes for rent by owner in Bermuda found on this webpage.
Design and relocate home rentals in Petersburg and Petersburg rental properties.
Devise and contrive home rentals in Warren Virginia, vacation homes in Warren, and Warren Virginia house rentals.
|
|
