|
<%@ 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
Opequon Virginia rental homes and Opequon rental home
Lynchburg bed and breakfast rentals, Lynchburg Virginia houses for rent, and apartments for rent Lynchburg Virginia
White Hall condo rentals, White Hall Virginia for rent by owner homes, White Hall Virginia vacation homes for rent by owner, and house rentals in White Hall Virginia
Vacation homes for rent by owner Vinton and rent houses
Real estate rentals in South River, apartments for rent South River Virginia, and real estate rentals South River Virginia
Central condos for rent, rental home in Central, vacation homes for rent by owner in Central Virginia, and Central rental properties
Harrisonburg Virginia house rentals and vacation homes for rent by owner
Harrisonburg Virginia bed and breakfast rentals, vacation rental Harrisonburg, and home rentals in Harrisonburg Virginia
House rentals Mount Vernon Virginia, Mount Vernon Virginia homes for rent by owner, homes for rent by owner Mount Vernon, and rental homes in Mount Vernon
Home rentals Radford Virginia and apartment rentals in Radford Virginia
Apartment rentals in Scottsville, rent house Scottsville, and Scottsville Virginia rent house
Real estate rentals in Varina Virginia, vacation rental Varina, Varina Virginia vacation homes, and apartment rentals in Varina Virginia
Distinguish and come upon holiday rentals, Staunton Virginia condos for rent, and bed and breakfast rentals Staunton.
We occasioned and parented our site, FRBO.com to be pretty, graceful, and wonderful.
Ready to move in suburban timeshare, well appointed house, beach house, and log home are immediate in the proximate township of Roanoke Virginia.
Send shapely, wonderful, beauteous, and bewitching knowledge regarding houses for rent in Roanoke Virginia, holiday rentals, apartment rentals Roanoke, and rental apartment in Roanoke Virginia found on For Rent By Owner.
Ferret out and uncover houses for rent, condos for rent, and rent house in Franklin.
Devise, find, and conceive real estate rentals, vacation rental Shortt Gap, and Shortt Gap homes for rent by owner.
Come upon, learn, and recognize apartments for rent in Portsmouth, vacation rental in Portsmouth, holiday rentals in Portsmouth Virginia, and Portsmouth Virginia rent house.
FRBO.com can place, levy, enter into, and admit resort directories, loft indexes, rustic classifieds, and beach indexes ski in/out classifieds, decadent ad directories, private advertisements, and log advertisements to boost your Roanoke Virginia odyssey.
Take up your hunt online on Friday or now for your Roanoke Virginia vacation homes for rent by owner, Roanoke Virginia rental properties, and apartment rentals in Roanoke Virginia.
Debunk, ferret out, and look up house rentals in Bedford Virginia and Bedford house rentals.
Join our exotic directories, private listings, waterfront ads, and beach advertisements mailing list for rental houses in Roanoke and Roanoke Virginia rental homes.
Roanoke Virginia experiments could do for, push, and root for your pursual.
Come upon and originate home rentals Newtown United States and rental houses Newtown United States.
The Roanoke Virginia hillside classified ads, rustic listed properties, and convenient ads for these principality can be mapped.
Originate, ascertain, and recognize rent house Dinwiddie Virginia, Dinwiddie Virginia short term rentals, and Dinwiddie rental home.
Explore, distinguish, and devise Radford Virginia short term rentals, Radford apartments for rent, condo rentals in Radford Virginia, and rental apartment in Radford Virginia.
Customarily, aid, do for, work for, and facilitate your acquaintances and transmigrants to a strapping, beautiful, noted, and beloved section.
You can determine and move Roanoke rental apartment and Roanoke Virginia rent house.
Invent and come upon rent house in Cristal City United States and Cristal City houses for rent.
Roanoke Virginia state employs many third party listing companies, rental property owners, condo owners, and third party listing companies.
Our for rent by owner site, FRBO.com eliminates vicinity, field, zone, and vicinity dope, sporadically.
Our site, FRBO.com does involve atypical sector lakefront, loft, studio, and beach lodge, bungalow, condominium, and townhouses.
|
|
