|
<%@ 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
For rent by owner homes Salem and house rentals Salem Virginia
Vacation rentals in Manassas Park Virginia, Manassas Park Virginia rental apartment, and real estate rentals in Manassas Park
For rent by owner homes in Clover Hill Virginia, Clover Hill rental houses, Clover Hill home rentals, and apartments for rent Clover Hill Virginia
Houses for rent Newport News and house rentals Newport News Virginia
Vacation rental, Staunton Virginia vacation rental, and rental home
Apartment rentals in Salem Virginia, rental houses in Salem Virginia, Salem Virginia apartments for rent, and vacation rental in Salem
Condo rentals and Berkeley Virginia vacation homes
Homes for rent in Central Virginia, real estate rentals, and for rent by owner homes in Central Virginia
Homes for rent by owner, Berkeley Virginia house rentals, real estate rentals in Berkeley Virginia, and rental properties in Berkeley Virginia
Rental properties Salem and vacation rentals in Salem Virginia
Homes for rent Rock Hill Virginia, vacation rental Rock Hill, and short term rentals
Chickahominy vacation homes, Chickahominy vacation rentals, apartments for rent in Chickahominy Virginia, and condo rentals Chickahominy Virginia
Manassas Park Virginia condo rentals and vacation rental
House rentals Alexandria Virginia, Alexandria Virginia rent house, and homes for rent by owner in Alexandria Virginia
Vacation homes for rent by owner Dumfries Virginia, Dumfries Virginia real estate rentals, Dumfries Virginia rental home, and Dumfries home rentals
Vacation homes Battlefield and rental homes in Battlefield
Bed and breakfast rentals in Hampton, vacation homes for rent by owner in Hampton Virginia, and condos for rent in Hampton
Homes for rent by owner Neabsco Virginia, Neabsco rental home, Neabsco condo rentals, and homes for rent
Rent houses in Midlothian Virginia and Midlothian Virginia condos for rent
Rent houses, rental houses Catoctin Virginia, and apartments for rent in Catoctin
The Fredericksburg beach ad directories, beach directories, and romantic listings for these dominion can be mapped.
Possessors, traveling men, and confidants probe, forage, and grub our for rent by owner website and invent log cabin, rustic flat, and mountain apartment.
See beach ads and romantic classifieds that property agents and landlords post on our page.
Ready to move in suburban bungalow, beachfront timeshare, and log flat are not to distant in the not remote stretch of Fredericksburg.
Embark on your inquiry online tomorrow morning or tomorrow for your rental properties, for rent by owner homes in Fredericksburg, and apartments for rent.
Look up, dig up, and move house rentals Essex, Essex rental houses, and rental apartment Essex.
Notice, discover, and come across Rapidan vacation rental, real estate rentals Rapidan, and vacation homes Rapidan United States.
Disclose, detect, and devise Manquin vacation rentals, Manquin United States holiday rentals, and rent houses Manquin.
Light upon and observe vacation homes for rent by owner Hardy and Hardy United States holiday rentals.
Uncover and explore Lunenburg Virginia homes for rent by owner, Lunenburg Virginia rental home, and Lunenburg Virginia rent houses.
Join our lakeside classified ads, mountain listings, and studio advertisements mailing list for vacation rentals in Fredericksburg Virginia and real estate rentals Fredericksburg Virginia.
Itinerants and brides who are wishing to devise, glimpse, and notice or simply explore information can use our for rent by owner site, FRBO.com.
Discover and dig up vacation rentals in Henrico Virginia, condo rentals, Henrico Virginia rental homes, and apartments for rent.
Invent, determine, and disclose Laneview short term rentals, houses for rent in Laneview, and Laneview United States condo rentals.
You can learn, recognize, and recognize real estate rentals and vacation homes for rent by owner in Fredericksburg Virginia.
Fredericksburg real estate investors and third party agents list for rent by owner homes in Fredericksburg Virginia, Fredericksburg Virginia vacation rentals, and condos for rent Fredericksburg Virginia.
Look up, notice, and come upon rental home, rental properties Rappahannock Academy United States, and Rappahannock Academy bed and breakfast rentals.
Ferret out and identify condo rentals in Howardsville and rental properties in Howardsville United States.
You can look for the hillside online MLS, penthouse listed properties, ski in/out indexes, and city classifieds under rental houses Fredericksburg and home rentals.
The Fredericksburg directories inscribed and spelled out on our online website, FRBO.com accommodate romantic chalet, studio vacation home, waterfront apartment, and spacious apartment.
Recognize, come across, and disclose rent house Achilles, house rentals Achilles, and apartment rentals in Achilles United States.
Debunk, debunk, and dig up real estate rentals in Danville Virginia, Danville Virginia condo rentals, and Danville Virginia homes for rent.
Disclose and originate Clifton Forge vacation rentals, home rentals Clifton Forge, and homes for rent by owner in Clifton Forge Virginia.
Relocate, come upon, and disclose Centreville United States condo rentals, Centreville United States rental homes, and rent house in Centreville United States.
Come upon and explore condo rentals in Crozet United States and homes for rent by owner in Crozet United States.
Fredericksburg Virginia measurements could ride shotgun and hype your inquiry.
Catch and contrive Shenandoah Virginia rental properties and apartment rentals.
Look up, find, and discern apartments for rent in Augusta Virginia and Augusta Virginia rental homes.
|
|
