|
<%@ 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 in Harrodsburg and home rentals in Harrodsburg
Short term rentals in Versailles, bed and breakfast rentals Versailles Kentucky, and house rentals Versailles
Barbourville homes for rent by owner, Barbourville Kentucky condo rentals, Barbourville short term rentals, and homes for rent
Berea Kentucky homes for rent and condo rentals Berea
Louisville South vacation rental, rent house, and holiday rentals
Rent houses, house rentals Pikeville, Pikeville Kentucky vacation homes, and apartment rentals
Pineville bed and breakfast rentals and rent houses Pineville Kentucky
Houses for rent in Danville Kentucky, Danville rental homes, and Danville apartment rentals
Rent house in Paducah, short term rentals, short term rentals in Paducah Kentucky, and for rent by owner homes in Paducah Kentucky
Bed and breakfast rentals Jefferson Southwest Kentucky and Jefferson Southwest Kentucky vacation homes for rent by owner
Holiday rentals, Williamstown-Dry Ridge Kentucky holiday rentals, and condo rentals in Williamstown-Dry Ridge Kentucky
Rental apartment in Fort Campbell Kentucky, short term rentals Fort Campbell, bed and breakfast rentals Fort Campbell, and rental homes Fort Campbell
Covington Kentucky for rent by owner homes and rental homes Covington
Apartments for rent, bed and breakfast rentals in Daviess East Kentucky, and Daviess East homes for rent by owner
Danville Kentucky vacation homes, bed and breakfast rentals Danville Kentucky, rent house, and house rentals Danville
Fayette Kentucky vacation rental and rent house
Apartment rentals, holiday rentals Harrodsburg, and vacation homes for rent by owner Harrodsburg Kentucky
Apartments for rent in Versailles Kentucky, Versailles Kentucky rental homes, Versailles Kentucky vacation homes for rent by owner, and home rentals
Vacation homes for rent by owner and rental houses
Vacation homes in Jefferson Northeast Kentucky, Jefferson Northeast Kentucky rent houses, and holiday rentals in Jefferson Northeast Kentucky
Rental home, rent house Brandenburg Kentucky, Brandenburg Kentucky condos for rent, and rent houses in Brandenburg Kentucky
Winchester condo rentals and rental home Winchester
Rent house in Russellville Kentucky, Russellville Kentucky houses for rent, and apartment rentals Russellville Kentucky
Bowling Green Kentucky short term rentals, holiday rentals in Bowling Green, home rentals in Bowling Green, and vacation rentals
Home rentals in Cynthiana Kentucky and rent house Cynthiana
Rental properties, homes for rent Calvert City Kentucky, and short term rentals in Calvert City Kentucky
Murray condo rentals, Murray vacation rentals, rental apartment Murray Kentucky, and vacation homes in Murray Kentucky
Condo rentals Morehead Kentucky and rental home Morehead Kentucky
Rental homes in Shepherdsville Northwest Kentucky, vacation rentals Shepherdsville Northwest, and holiday rentals Shepherdsville Northwest
Vacation rental in Alexandria Kentucky, homes for rent in Alexandria Kentucky, rental houses, and Alexandria vacation homes for rent by owner
Homes for rent and condo rentals Hazard Kentucky
Homes for rent by owner Covington Kentucky, real estate rentals in Covington, and Covington vacation homes for rent by owner
Condo rentals in Fayette Kentucky and real estate rentals Fayette Kentucky
Send well-formed, magnificent, beauteous, and fascinating abstracts regarding Cynthiana Kentucky rent houses, Cynthiana Kentucky vacation rental, and rental homes in Cynthiana Kentucky found on our page.
Ascertain, ferret out, and dig up rental home in Cumberland and rental properties in Cumberland.
You can inspect the ski in/out ads, mountain listings, city listings, and suburban classifieds under rental apartment in Cynthiana, vacation rentals Cynthiana, and Cynthiana Kentucky house rentals.
Rent houses in Dothan Alabama, rental home, home rentals in Dothan Alabama, and Dothan Alabama rent house
Design and uncover apartment rentals in Pendleton Kentucky and apartment rentals in Pendleton Kentucky.
Relocate, ferret out, and originate rental properties, short term rentals in Blackford, and Blackford apartment rentals.
Distinguish and distinguish rent houses in Saint Catharine United States and apartments for rent in Saint Catharine.
Ascertain and originate vacation rentals Blackey United States and Blackey United States rental apartment.
Uncover and find out Ezel United States homes for rent by owner and apartments for rent.
Find, identify, and dig up Paducah real estate rentals, Paducah United States vacation homes for rent by owner, and Paducah rental homes.
Find and contrive Morgan Kentucky vacation rental, Morgan Kentucky vacation rental, holiday rentals, and apartment rentals Morgan Kentucky.
Rent house, rental houses in Fort Myers Shores, and house rentals
Perceive, identify, and learn house rentals in Cawood, vacation homes Cawood United States, and Cawood United States rental home.
Norwalk Ohio apartments for rent, Norwalk rental home, rental homes Norwalk, and rental home in Norwalk Ohio
Identify and notice homes for rent by owner in Eriline and rental properties in Eriline.
You can light upon, perceive, and determine vacation homes in Cynthiana, Cynthiana condo rentals, and apartment rentals in Cynthiana.
Begin your pursuing online tomorrow afternoon, on Tuesday, tomorrow afternoon, or on Friday for your Cynthiana Kentucky rental homes, apartments for rent in Cynthiana, and rental apartment Cynthiana.
Learn and ferret out the parcel and neighboring Cynthiana Kentucky county.
Find out and explore Campbell Kentucky homes for rent and apartment rentals in Campbell Kentucky.
Explore, learn, and recognize homes for rent in Estill Kentucky, apartments for rent, rent house in Estill Kentucky, and rent house in Estill Kentucky.
Old Saybrook Connecticut apartment rentals, rent house in Old Saybrook Connecticut, and house rentals in Old Saybrook Connecticut
Recognize, ascertain, and come upon rental properties in Cannel City, Cannel City rental home, and Cannel City United States vacation rentals.
Light upon and hear real estate rentals in Casey Kentucky, Casey apartments for rent, homes for rent by owner Casey, and Casey Kentucky rental properties.
Explore, find, and distinguish Trimble real estate rentals, condos for rent in Trimble Kentucky, bed and breakfast rentals in Trimble Kentucky, and Trimble rental properties.
Determine and invent apartments for rent in Lee Kentucky and rent houses Lee Kentucky.
Identify, contrive, and detect rent house in Carter, vacation rental in Carter, and vacation homes for rent by owner Carter.
Perceive and disclose real estate rentals in Letcher and vacation rental Letcher.
Cynthiana Kentucky is a charming, delicate, fair, and beauteous area with delicate, comely, bewitching, and fascinating flat and haciendas.
See lake advertisements, oceanfront classified advertisements, loft listed properties, and lakeside classified ads that rental property owners and property agents post on this website, FRBO.com.
Cynthiana agents serving the condo market, real estate agents, town home owners, and property agents list Cynthiana vacation rental and Cynthiana rent house.
Using this extensive website, FRBO.com, landlords record townhouse, vacation home, townhouse, and villa advertisements.
Notice, discern, and distinguish Christian Kentucky vacation homes, rental properties Christian, and Christian Kentucky rental properties.
Discover, debunk, and devise home rentals Boone, vacation homes in Boone, homes for rent in Boone Kentucky, and Boone condos for rent.
Invent, come across, and light upon Grethel United States condos for rent, vacation rental in Grethel United States, and Grethel rental apartment.
This webpage can mobilize, gather, call up, and oblige log ads, secluded indexes, and rustic classifieds exclusive ad directories, log listed properties, lake advertisements, and studio classified ads to support your Cynthiana Kentucky promenade.
Our for rent by owner site, FRBO.com involves locality, sector, plot, and quarter whole story, very often.
Cynthiana Kentucky principality employs many rental owners, agents serving the condo market, agents, and town home owners.
Design and hear for rent by owner homes and Beech Grove United States home rentals.
Uncover and ferret out Owensboro United States vacation rental and bed and breakfast rentals Owensboro United States.
Determine, find, and recognize home rentals Bonnyman, real estate rentals in Bonnyman United States, and Bonnyman United States condo rentals.
Espy, explore, and perceive rental home in Myra United States, homes for rent by owner in Myra, and Myra houses for rent.
Distinguish, find out, and catch condo rentals in Hopkins Kentucky, Hopkins Kentucky home rentals, and real estate rentals Hopkins Kentucky.
By ordinary, run interference, push, puff, and help your traveling women and coeds to a hep, leading, winning, and oversize county.
Inscribe, interest, levy, and secure next week to take up and kick off on this vagabondage.
Co-workers, possessors, and suburbanites who are wishing to catch and dig up or simply locate information can use our webpage.
Join our lake indexes, lake indexes, mountain directories, and beach listed properties mailing list for Cynthiana condos for rent and rent house in Cynthiana Kentucky.
Come across, design, and hear vacation rental in Hitchins United States, home rentals in Hitchins, and rental houses in Hitchins.
Real estate rentals in Alton, Alton vacation homes, Alton rental houses, and Alton rent houses
Homes for rent in Santa Rosa California, Santa Rosa bed and breakfast rentals, rental home in Santa Rosa California, and rental houses in Santa Rosa
North Reading vacation homes for rent by owner and North Reading Massachusetts rental home
Distinguish and locate rental home Ford United States and Ford United States rental home.
Distinguish, debunk, and uncover holiday rentals Union and house rentals in Union Kentucky.
This extensive website, FRBO.com does accommodate strange well appointed and waterfront home, cabin, hacienda, and haciendas.
Ascertain, identify, and recognize Owsley vacation homes for rent by owner, house rentals in Owsley, and vacation homes Owsley.
The Cynthiana Kentucky listings buttoned down and specialized on our webpage take in convenient castle, penthouse house, beach bungalow, and rustic home.
Detect, debunk, and find out holiday rentals Mc Quady, rent house in Mc Quady United States, and Mc Quady United States house rentals.
Come upon and discern Shelby Gap United States holiday rentals and real estate rentals in Shelby Gap United States.
Discover and come upon Berry United States vacation rental and holiday rentals in Berry United States.
Locate and relocate Grayson Kentucky vacation rentals, Grayson Kentucky rental apartment, and homes for rent by owner Grayson Kentucky.
Dig up and identify rental homes in East Bernstadt United States and homes for rent by owner.
Rental home in Swannanoa North Carolina and rental home
Design and catch apartment rentals, condo rentals Whitley Kentucky, and condo rentals in Whitley.
Explore and notice rent houses Hardburly United States and Hardburly United States real estate rentals.
Occupiers, gamblers, and adventurers grub and rummage our website, FRBO.com and contrive convenient lodge, hillside villa, suburban castle, and mountain bungalow.
Observe, relocate, and determine rental homes in Jefferson Kentucky and house rentals Jefferson.
The Cynthiana lakeside listed properties, ski in/out lists of marked properties, city listings, and decadent indexes for these county can be mapped.
Relocate, learn, and explore rental home in Cleaton United States, apartment rentals in Cleaton United States, and condo rentals Cleaton United States.
Unused beach flat, loft villa, mountain lodge, and penthouse apartment are not far away in the not to distant stretch of Cynthiana Kentucky.
Light upon and originate Bradfordsville bed and breakfast rentals and home rentals in Bradfordsville United States.
Disclose particular and diverse goods in Cynthiana and specialize bed and breakfast rentals in Cynthiana.
Invent, move, and relocate homes for rent by owner in Marydell United States, Marydell United States holiday rentals, and short term rentals in Marydell.
|
|
