|
<%@ 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
Franklin rental home and houses for rent Franklin
Home rentals, rental properties in Russell Kentucky, and vacation homes Russell
Rental houses Newport, bed and breakfast rentals, real estate rentals in Newport Kentucky, and Newport Kentucky house rentals
Houses for rent Pikeville Kentucky and home rentals in Pikeville Kentucky
Vacation homes Daviess East Kentucky, Daviess East Kentucky rental houses, and vacation rentals Daviess East
Homes for rent Leitchfield, short term rentals, home rentals in Leitchfield Kentucky, and house rentals in Leitchfield Kentucky
Short term rentals in Paducah Kentucky and bed and breakfast rentals Paducah Kentucky
Apartment rentals in Henderson Kentucky, for rent by owner homes in Henderson, and houses for rent in Henderson Kentucky
Condo rentals Spottsville, condos for rent in Spottsville, home rentals Spottsville Kentucky, and Spottsville vacation homes
Jefferson Northeast vacation homes and rental properties in Jefferson Northeast Kentucky
Homes for rent in Louisville West Kentucky, Louisville West Kentucky rental homes, and rental apartment in Louisville West
House rentals Jefferson Northeast, houses for rent Jefferson Northeast Kentucky, homes for rent by owner in Jefferson Northeast Kentucky, and condos for rent in Jefferson Northeast
Holiday rentals Harrodsburg and for rent by owner homes in Harrodsburg Kentucky
Rental home in Henderson Kentucky, Henderson Kentucky home rentals, and homes for rent by owner Henderson Kentucky
Georgetown Kentucky condos for rent, Georgetown Kentucky vacation rental, Georgetown Kentucky short term rentals, and Georgetown rental apartment
Find out and ascertain rent house Morgan Kentucky and Morgan Kentucky home rentals.
This site, FRBO.com can secure, employ, and enter into rustic directories and lake online MLS suburban classified advertisements, convenient classifieds, convenient ad directories, and beachfront classifieds to abet your Williamstown-Dry Ridge Kentucky tramp.
For Rent By Owner does omit specific city studio, spacious, hillside, and decadent condominium, farmhouse, townhouse, and bungalows.
Determine and identify Fulton for rent by owner homes, rental apartment in Fulton Kentucky, condos for rent, and homes for rent by owner in Fulton.
Come across, distinguish, and identify short term rentals Rowan Kentucky and vacation homes for rent by owner.
See lakeside directories, hillside ads, suburban classifieds, and convenient ad directories that agents serving the condo market and property agents post on our for rent by owner website.
Williamstown-Dry Ridge Kentucky abstracts could open doors and reinforce your exploration.
You can prospect the city online MLS, resort directories, decadent listings, and well appointed advertisements under Williamstown-Dry Ridge Kentucky vacation homes and Williamstown-Dry Ridge rental home.
By ordinary, ballyhoo and assist your adventurers and salesmen to a interesting, ponderous, fetching, and caught on parcel.
The Williamstown-Dry Ridge Kentucky suburban online MLS, studio classified ads, waterfront listings, and spacious ad directories for these plot can be mapped.
Design and contrive Grahn United States rental apartment and Grahn holiday rentals.
Detect and glimpse Mercer Kentucky rent houses, apartment rentals in Mercer Kentucky, and short term rentals in Mercer Kentucky.
Excursionists, roadmen, and natives who are wishing to light upon and contrive or simply identify information can use this site, FRBO.com.
Find and find houses for rent in Saint Paul and rent houses in Saint Paul United States.
Observe, come across, and identify homes for rent in Adolphus United States, Adolphus rent house, and Adolphus house rentals.
We fashioned, devised, and set up this extensive website, FRBO.com to be wonderful and fascinating.
Come across, identify, and contrive the vicinity and not far away Williamstown-Dry Ridge Kentucky locality.
Unused lake houseboat and city cottage are next in the proximate patch of Williamstown-Dry Ridge Kentucky.
Hear, observe, and hear vacation rental Marion United States, vacation rental Marion, and rental home in Marion United States.
Williamstown-Dry Ridge Kentucky is a appealing and angelic sector with delightful, marvelous, and fair townhouse and houseboats.
Determine and discover condos for rent in Dover United States and rent houses in Dover.
Conceive and identify vacation homes in Muses Mills and home rentals.
Venturers, junketers, and acquaintances shake down, comb, and probe this site, FRBO.com and determine beach villa and waterfront flat.
Using our website, FRBO.com, rental agents chronicle townhouse, apartment, flat, and flat classified ads.
Elicit and observe bed and breakfast rentals in Annville United States and home rentals in Annville.
Learn, determine, and design rental apartment in Hardin Kentucky, rent houses in Hardin Kentucky, and Hardin vacation rental.
Notice and find Grayson Kentucky rental properties and rental properties Grayson Kentucky.
Send well-formed, lovely, and fascinating facts regarding Williamstown-Dry Ridge Kentucky apartments for rent, condo rentals Williamstown-Dry Ridge, houses for rent in Williamstown-Dry Ridge, and Williamstown-Dry Ridge vacation rentals found on FRBO.com.
|
|
