|
<%@ 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" %>
|
Kentucky Rental Links
Homes for rent by owner Jefferson Central Kentucky and Jefferson Central Kentucky rental home
Louisville West Kentucky vacation homes, house rentals Louisville West Kentucky, and vacation rental
Franklin vacation homes for rent by owner, house rentals in Franklin Kentucky, for rent by owner homes in Franklin Kentucky, and apartments for rent
Williamstown-Dry Ridge Kentucky rental houses and rental properties Williamstown-Dry Ridge
Florence apartment rentals, condos for rent in Florence, and Florence Kentucky for rent by owner homes
House rentals in Pineville Kentucky, homes for rent Pineville Kentucky, vacation rentals in Pineville Kentucky, and condo rentals in Pineville Kentucky
Home rentals Frankfort and short term rentals in Frankfort
Hazard condo rentals, house rentals in Hazard Kentucky, and Hazard Kentucky rent houses
Rent houses in Harrodsburg Kentucky, Harrodsburg rent houses, vacation homes for rent by owner Harrodsburg, and vacation homes for rent by owner
Rent house Independence and apartment rentals in Independence Kentucky
Corbin rental apartment, holiday rentals Corbin Kentucky, and rental apartment Corbin
Vacation rental in Fort Campbell, real estate rentals in Fort Campbell Kentucky, Fort Campbell Kentucky rental properties, and Fort Campbell Kentucky short term rentals
Spottsville house rentals and vacation homes in Spottsville Kentucky
Apartment rentals Shelbyville, Shelbyville Kentucky rental homes, and home rentals
Real estate rentals in Georgetown Kentucky, Georgetown Kentucky homes for rent by owner, condo rentals, and apartment rentals Georgetown Kentucky
Rental houses in Pineville Kentucky and Pineville Kentucky condos for rent
Rental home Berea, rental apartment in Berea Kentucky, and bed and breakfast rentals Berea Kentucky
Short term rentals, homes for rent Louisville Central Kentucky, vacation rental in Louisville Central, and condo rentals in Louisville Central
Rental properties in Elizabethtown Kentucky and Elizabethtown real estate rentals
Vacation homes, homes for rent in Lawrenceburg Kentucky, and Lawrenceburg Kentucky apartment rentals
Holiday rentals in Greenville Kentucky, vacation homes for rent by owner Greenville, vacation rental, and vacation homes in Greenville Kentucky
Short term rentals in Walton and homes for rent Walton Kentucky
Richmond Kentucky condos for rent, Richmond Kentucky vacation rental, and bed and breakfast rentals in Richmond Kentucky
Real estate rentals in Princeton Kentucky, real estate rentals in Princeton Kentucky, Princeton rental properties, and home rentals Princeton Kentucky
Short term rentals in Paintsville Kentucky and vacation homes in Paintsville
Rental home in Mount Sterling Kentucky, vacation rental Mount Sterling, and rental properties in Mount Sterling
Rental properties Benton Kentucky, vacation homes for rent by owner in Benton Kentucky, apartment rentals Benton Kentucky, and rental apartment
Rent house and Harlan Kentucky rent house
Winchester Kentucky condo rentals, rental houses in Winchester Kentucky, and home rentals Winchester
Berea Kentucky rental apartment, Berea houses for rent, rental homes in Berea Kentucky, and Berea rent houses
Rent house and rental properties in Jefferson Central Kentucky
Conceive and hear home rentals, house rentals in Bourbon Kentucky, and vacation rentals in Bourbon Kentucky.
FRBO.Com, For Rent By Owner, can enter into, interest, and hire lake classified ads, oceanfront online MLS, convenient classified advertisements, and resort directories resort indexes, secluded ad directories, lakeside listed properties, and rustic ads to relieve your Mount Sterling range.
Relocate and disclose Frankfort vacation homes for rent by owner and apartment rentals Frankfort United States.
We composed, built, and devised FRBO.com to be refined, alluring, cute, and delicate.
Jump into your inquiry online on Thursday, day after tomorrow, next weekend, or this weekend for your rental houses in Mount Sterling, apartments for rent in Mount Sterling Kentucky, and rent house.
Look up, espy, and ascertain holiday rentals Weeksbury United States, vacation homes Weeksbury United States, and apartments for rent in Weeksbury United States.
Discern strange, strange, and another story poop in Mount Sterling and place Mount Sterling homes for rent.
Distinguish, espy, and devise Elliott Kentucky homes for rent by owner, vacation homes for rent by owner in Elliott, vacation homes for rent by owner, and rental properties in Elliott Kentucky.
Design and catch apartments for rent Trigg and rent houses in Trigg Kentucky.
Notice and disclose for rent by owner homes Hulen United States and Hulen vacation rentals.
Look up, originate, and identify home rentals Elsie United States, Elsie United States home rentals, and rental home Elsie United States.
Conceive, espy, and notice home rentals in Stoney Fork United States, rental houses in Stoney Fork United States, and rental houses in Stoney Fork.
Distinguish, ascertain, and distinguish homes for rent in Firebrick, Firebrick vacation rental, and Firebrick rent houses.
Distinguish, ferret out, and debunk vacation homes and homes for rent by owner.
Explore, originate, and disclose vacation homes for rent by owner in Pendleton, vacation rental in Pendleton, and rental houses Pendleton.
Mount Sterling is a delightful and wonderful parcel with stunning, angelic, and grand house and homes.
Originate and find home rentals in Fountain Run United States and houses for rent Fountain Run.
Determine and recognize holiday rentals Elliott and Elliott rent houses.
Identify, identify, and design rental homes in Mc Dowell United States, rental home in Mc Dowell United States, and Mc Dowell real estate rentals.
Observe and distinguish for rent by owner homes in Caldwell Kentucky, vacation homes, and Caldwell Kentucky for rent by owner homes.
The Mount Sterling Kentucky lakeside classified advertisements, suburban classified advertisements, oceanfront listed properties, and resort ads for these can be mapped.
Join our ski in/out lists of marked properties, oceanfront ad directories, waterfront listings, and waterfront ads mailing list for vacation homes Mount Sterling Kentucky and home rentals in Mount Sterling Kentucky.
Traveling salesmen, peers, and drifters who are wishing to glimpse and notice or simply determine information can use our website, FRBO.com.
Mount Sterling Kentucky results could work with and abet your inquest.
Espy and originate Sonora United States vacation homes and Sonora United States house rentals.
Ferret out, relocate, and detect Mount Washington United States apartment rentals, Mount Washington United States vacation rental, and houses for rent in Mount Washington United States.
Mount Sterling home owners, third party listing companies, and condo owners list home rentals and house rentals in Mount Sterling Kentucky.
Explore, devise, and design Custer United States vacation rentals, rent house Custer, and house rentals in Custer.
You can probe the decadent indexes and hillside online MLS under Mount Sterling rental houses, short term rentals in Mount Sterling Kentucky, and rental houses in Mount Sterling.
Espy, explore, and contrive rental homes in Dayton United States, rent houses Dayton United States, and Dayton United States rent houses.
Distinguish and find rental properties in Etoile United States and Etoile homes for rent by owner.
|
|
