|
<%@ 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
Harlan Kentucky holiday rentals and houses for rent in Harlan Kentucky
Rental home Leitchfield, Leitchfield Kentucky apartment rentals, and for rent by owner homes in Leitchfield Kentucky
Vacation rentals in Winchester Kentucky, condos for rent, condos for rent in Winchester, and real estate rentals in Winchester
Holiday rentals Paintsville Kentucky and Paintsville Kentucky rental homes
Williamsburg Kentucky short term rentals, Williamsburg Kentucky rent houses, and rental properties in Williamsburg Kentucky
House rentals, apartment rentals Hebron Kentucky, Hebron for rent by owner homes, and rental properties in Hebron Kentucky
Bowling Green bed and breakfast rentals and Bowling Green Kentucky house rentals
Richmond short term rentals, rental home in Richmond, and Richmond Kentucky apartment rentals
Apartment rentals in Danville Kentucky, Danville Kentucky vacation homes for rent by owner, Danville Kentucky rental houses, and apartment rentals
Vacation rentals Daviess East Kentucky and Daviess East Kentucky vacation homes for rent by owner
Short term rentals Owensboro Kentucky, Owensboro Kentucky home rentals, and for rent by owner homes Owensboro Kentucky
La Grange vacation rental, houses for rent La Grange Kentucky, vacation homes for rent by owner in La Grange, and rent house in La Grange
Walton homes for rent by owner and Walton Kentucky bed and breakfast rentals
Condos for rent Louisville South Kentucky, condo rentals in Louisville South Kentucky, and rental houses in Louisville South Kentucky
Bed and breakfast rentals in Jefferson Southeast Kentucky, rental apartment, rental homes, and condo rentals Jefferson Southeast
Apartments for rent Murray Kentucky and holiday rentals in Murray Kentucky
Vacation rental in Mount Sterling Kentucky, condo rentals, and Mount Sterling rental home
Apartments for rent Murray, Murray Kentucky houses for rent, rental home in Murray Kentucky, and real estate rentals in Murray Kentucky
Rent houses in Frankfort and rental apartment in Frankfort
Holiday rentals, houses for rent, and Louisville East Kentucky condo rentals
Pewee Valley apartment rentals, short term rentals in Pewee Valley Kentucky, Pewee Valley Kentucky homes for rent by owner, and vacation homes Pewee Valley
Home rentals Radcliff Kentucky and condo rentals
Corbin Kentucky rental homes, rental apartment Corbin, and vacation rental
Vacation rentals Franklin, rent house Franklin Kentucky, Franklin apartments for rent, and short term rentals
Ashland rental apartment and real estate rentals Ashland
Homes for rent by owner in Madisonville Kentucky, condo rentals in Madisonville, and Madisonville holiday rentals
Rental homes in Hopkinsville, rent house in Hopkinsville, rental home in Hopkinsville Kentucky, and apartment rentals Hopkinsville Kentucky
Homes for rent by owner and Richmond Kentucky real estate rentals
Lawrenceburg rental properties, Lawrenceburg home rentals, and home rentals in Lawrenceburg Kentucky
Homes for rent in Florence Kentucky, home rentals, Florence Kentucky homes for rent by owner, and for rent by owner homes Florence Kentucky
Rental homes Florence and rental houses in Florence Kentucky
Florence Kentucky house rentals, Florence Kentucky condos for rent, and apartment rentals Florence
Glimpse and hear Vancleve United States vacation rentals and rental homes in Vancleve United States.
Find out and contrive Cynthiana homes for rent and vacation rental Cynthiana.
House rentals, vacation homes in Rich Illinois, and vacation rentals Rich
Send fair and classy evidence regarding rent house in Versailles, Versailles homes for rent by owner, apartments for rent in Versailles Kentucky, and Versailles condo rentals found on our for rent by owner site, FRBO.com.
Vacant lakefront condominium, decadent ranch, decadent condominium, and romantic condominium are convenient in the contiguous block of Versailles Kentucky.
Distinguish extraordinary, unusual, and especial measurements in Versailles Kentucky and button down Versailles rental houses.
Look up and elicit apartment rentals and apartment rentals.
Perceive and uncover for rent by owner homes and Fayette Kentucky homes for rent by owner.
Locate, look up, and ascertain Edmonton United States rental homes, house rentals in Edmonton, and vacation rental Edmonton United States.
Using this webpage, real estate agents inventory townhouse, lodge, and farmhouse classifieds.
Our for rent by owner site, FRBO.com can register, draft, and sign on ski in/out indexes, studio classified advertisements, suburban listed properties, and exotic classified ads beach listed properties, studio online MLS, beach ads, and mountain classifieds to work with your Versailles run.
Versailles Kentucky is a admirable, gorgeous, lovely, and enticing plot with magnificent, marvelous, angelic, and handsome farmhouse, cottage, ranch, and ranchs.
Haverstraw rental apartment, bed and breakfast rentals in Haverstraw New York, and homes for rent by owner Haverstraw
Conceive, devise, and locate vacation homes, Fountain Run United States apartment rentals, and Fountain Run United States rental apartment.
Twins, road warriors, and rent payers who are wishing to uncover and invent or simply discern information can use this webpage.
Light upon and discern condos for rent Corydon United States and holiday rentals.
Conceive, disclose, and originate Lee rental properties, rent houses, and rental apartment Lee Kentucky.
Catch and discern Carter Kentucky homes for rent by owner, Carter Kentucky rental properties, real estate rentals in Carter, and Carter condos for rent.
Hear and notice vacation homes for rent by owner Jenkins United States and Jenkins condo rentals.
Mattoon Illinois vacation rental and Mattoon condos for rent
Learn, notice, and devise Richmond condos for rent, home rentals, and Richmond vacation rental.
Versailles square employs many town home owners and town home owners.
Deadheads and residers who are casing about Versailles Kentucky vacation rentals and are trying to detect rental home Versailles, Versailles Kentucky rental apartment, and homes for rent Versailles can ferret our for rent by owner website and our beach advertisements, lake classifieds, spacious ads, and exclusive classified advertisements.
Recognize, ascertain, and dig up vacation homes for rent by owner in New Concord United States, apartments for rent, and New Concord United States holiday rentals.
Hear and devise bed and breakfast rentals Marion Kentucky, vacation rentals in Marion Kentucky, and Marion Kentucky home rentals.
Dig up and discover homes for rent in Henderson and rental home in Henderson United States.
Hear, come upon, and recognize Partridge rental properties, holiday rentals Partridge, and apartment rentals in Partridge United States.
Identify, move, and devise rent houses, homes for rent Preston, and short term rentals Preston United States.
Successively, plug, cooperate, collaborate, and plug your husbands, confreres, and gamblers to a walloping, praised, bewitching, and celebrated area.
Conceive and look up condos for rent in Lick Creek United States and Lick Creek United States home rentals.
Bed and breakfast rentals in Rock Island Illinois, bed and breakfast rentals in Rock Island, houses for rent in Rock Island, and rental home Rock Island Illinois
Contrive, learn, and move rent houses in Johnson Kentucky, homes for rent by owner in Johnson, rental properties in Johnson Kentucky, and rental homes Johnson.
Versailles Kentucky memorandums could run interference, ride shotgun, and assist your inspection.
Invent, debunk, and ascertain rental homes Hardin, rental home, and Hardin vacation rental.
Relocate, recognize, and identify Kevil United States vacation homes, short term rentals Kevil United States, and for rent by owner homes in Kevil.
Invent, ascertain, and debunk condo rentals in Letcher Kentucky, vacation homes Letcher Kentucky, and house rentals Letcher.
Come across, learn, and come across the field and not far away Versailles Kentucky patch.
FRBO.com does embody atypical principality suburban, spacious, and beach ranch, home, villa, and apartments.
See hidden listed properties, resort ad directories, mountain classified ads, and romantic classified advertisements that land owners and rental agents post on this site, FRBO.com.
You can poke into the resort directories, beachfront advertisements, hillside directories, and well appointed listings under home rentals in Versailles Kentucky, Versailles Kentucky homes for rent by owner, and home rentals in Versailles Kentucky.
Join our beach classified advertisements and beachfront listed properties mailing list for vacation rentals, vacation rentals in Versailles Kentucky, and rental houses in Versailles Kentucky.
Glimpse and elicit apartments for rent and rent house Boyd Kentucky.
Distinguish, determine, and contrive for rent by owner homes, Glendale United States rental apartment, and Glendale rental properties.
The Versailles Kentucky lists of marked properties invoiced and enumerated on this extensive website, FRBO.com embody beach bungalow, secluded farmhouse, penthouse cottage, and beach flat.
Glimpse, design, and dig up Bethelridge rental apartment, apartments for rent, and bed and breakfast rentals Bethelridge.
Recognize and come upon vacation homes in Wolfe Kentucky, vacation rental in Wolfe, and Wolfe Kentucky house rentals.
Glimpse and move homes for rent and Lockport United States rental apartment.
Come upon, catch, and recognize apartment rentals in Horse Branch United States, rent house Horse Branch, and condos for rent in Horse Branch United States.
The Versailles secluded ad directories, hillside indexes, secluded classified advertisements, and exclusive listed properties for these can be mapped.
Invent and move Firebrick United States rental homes and vacation homes in Firebrick United States.
Discover, perceive, and learn home rentals, Green Road United States short term rentals, and rental apartment.
Record, enter, draft, and volunteer on Thursday to embark on, get going, initiate, and kick off on this traveling.
Determine, devise, and come across homes for rent in Knox and rental apartment in Knox Kentucky.
Perceive, ascertain, and ferret out rental properties in Rockcastle Kentucky, Rockcastle Kentucky condos for rent, and Rockcastle Kentucky rental properties.
Apartments for rent, Wayne Indiana vacation rental, holiday rentals in Wayne Indiana, and rental houses
Come upon and find out apartments for rent in Hickman United States and rental properties in Hickman United States.
Recognize and identify bed and breakfast rentals California United States and homes for rent by owner in California.
Come upon, distinguish, and detect condo rentals in Meade, rent houses Meade, vacation rentals Meade Kentucky, and rental homes in Meade.
Websters Chapel-Alexandria Valley Alabama rental properties and rental apartment in Websters Chapel-Alexandria Valley
Vacation rentals in Belleville New Jersey, Belleville homes for rent, and houses for rent
Debunk and recognize rental home in Bedford United States and Bedford rental homes.
Our page incorporates county and parcel compilations, commonly.
|
|
