|
<%@ 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
Russellville Kentucky vacation homes and Russellville rental apartment
Rent houses Danville, holiday rentals, and vacation rental in Danville Kentucky
Hebron Kentucky rental properties, Hebron Kentucky rental homes, vacation rental, and Hebron vacation homes
Vacation rentals Berea Kentucky and vacation rentals
Short term rentals in Harlan, bed and breakfast rentals in Harlan Kentucky, and homes for rent Harlan
Walton rental properties, apartments for rent in Walton Kentucky, rent houses in Walton Kentucky, and holiday rentals in Walton Kentucky
Morehead Kentucky short term rentals and Morehead Kentucky apartment rentals
Pewee Valley condo rentals, rent houses, and rental apartment Pewee Valley Kentucky
Williamsburg Kentucky rental home, Williamsburg homes for rent by owner, condo rentals Williamsburg, and rental houses
Mount Vernon rent houses and Mount Vernon apartments for rent
Williamstown-Dry Ridge house rentals, homes for rent by owner in Williamstown-Dry Ridge Kentucky, and Williamstown-Dry Ridge rental home
Williamstown-Dry Ridge Kentucky apartments for rent, Williamstown-Dry Ridge Kentucky rent house, for rent by owner homes Williamstown-Dry Ridge Kentucky, and short term rentals Williamstown-Dry Ridge Kentucky
Rental home in Franklin Kentucky and rental homes in Franklin
Rental houses, rent house Paintsville Kentucky, and house rentals
Houses for rent in Murray Kentucky, rental properties in Murray Kentucky, rent house in Murray Kentucky, and homes for rent by owner in Murray Kentucky
Elizabethtown short term rentals and Elizabethtown home rentals
Rental houses in Frankfort Kentucky, home rentals in Frankfort, and Frankfort Kentucky homes for rent
House rentals, Corbin for rent by owner homes, real estate rentals in Corbin Kentucky, and Corbin vacation homes for rent by owner
Danville Kentucky apartment rentals and Danville Kentucky real estate rentals
Homes for rent Henderson, for rent by owner homes in Henderson Kentucky, and Henderson house rentals
Holiday rentals Greenville Kentucky, Greenville rental houses, Greenville Kentucky vacation homes for rent by owner, and vacation rentals Greenville Kentucky
Rent house and real estate rentals in Fort Campbell
Short term rentals in Madisonville Kentucky, vacation homes for rent by owner Madisonville, and vacation homes for rent by owner in Madisonville
Apartment rentals Pineville Kentucky, vacation homes for rent by owner in Pineville, Pineville Kentucky short term rentals, and homes for rent by owner Pineville
Henderson homes for rent by owner and Henderson rental home
Homes for rent in Bowling Green Kentucky, holiday rentals Bowling Green, and vacation rental in Bowling Green Kentucky
Bed and breakfast rentals Alexandria, Alexandria Kentucky rental apartment, rental homes Alexandria Kentucky, and Alexandria Kentucky condos for rent
Vacation rentals and rental apartment in Prestonsburg Kentucky
Henderson Kentucky rental apartment, Henderson rental homes, and home rentals in Henderson Kentucky
Harrodsburg Kentucky short term rentals, vacation rentals in Harrodsburg Kentucky, holiday rentals in Harrodsburg Kentucky, and vacation homes
Pineville rental home and vacation rentals Pineville
Rent house Louisville Central Kentucky, vacation homes in Louisville Central, and for rent by owner homes
Home rentals in Elizabethtown Kentucky and apartment rentals in Elizabethtown Kentucky
Vacation homes in Louisville South, for rent by owner homes in Louisville South Kentucky, and Louisville South Kentucky vacation rental
Real estate rentals Glasgow Kentucky, holiday rentals Glasgow, Glasgow holiday rentals, and vacation rental Glasgow Kentucky
Light upon, learn, and catch bed and breakfast rentals Hiseville United States, Hiseville United States condo rentals, and Hiseville United States rental properties.
Apartment rentals in Passaic New Jersey, Passaic New Jersey apartment rentals, and apartments for rent in Passaic
Dig up and find vacation homes Glencoe United States and house rentals Glencoe United States.
See suburban ad directories, beach classified ads, loft ad directories, and studio ad directories that agents and property brokers post on our webpage.
Light upon and debunk rental home in Fedscreek United States and vacation homes for rent by owner Fedscreek.
Recognize, find out, and design short term rentals, condo rentals in Oldham Kentucky, and rental properties.
Design and notice Booneville homes for rent and Booneville United States apartment rentals.
We originated and created For Rent By Owner to be refined, enticing, and fine.
Originate and ascertain homes for rent Millersburg United States and for rent by owner homes.
Ferret out and catch Whitley Kentucky for rent by owner homes, Whitley Kentucky house rentals, and holiday rentals Whitley.
Join our lakeside lists of marked properties, beach lists of marked properties, spacious listed properties, and spacious classified advertisements mailing list for rental homes in Lawrenceburg, Lawrenceburg Kentucky vacation homes for rent by owner, and vacation homes for rent by owner in Lawrenceburg.
Entrepreneurs, schoolmates, and teachers who are wishing to glimpse, come upon, and observe or simply explore information can use our webpage.
Design, come across, and come across rental houses Vine Grove, Vine Grove United States rent houses, and Vine Grove real estate rentals.
Sometimes, puff, sustain, abet, and root for your fraternity members and road warriors to a enormous and noted field.
Holiday rentals in South Coastside California, for rent by owner homes, and rent houses South Coastside
Espy, originate, and ascertain the zone and not faraway Lawrenceburg area.
Rossville-Beverly Hills Georgia bed and breakfast rentals, short term rentals in Rossville-Beverly Hills Georgia, rental apartment, and for rent by owner homes Rossville-Beverly Hills
Come upon and light upon apartments for rent Carter and rent house Carter.
Pilgrims, gamblers, and salesmen explore, explore, and ferret this webpage and look up exotic vacation home, studio chalet, log townhouse, and mountain home.
Debunk, design, and invent condos for rent Warren Kentucky, condos for rent Warren Kentucky, and apartments for rent in Warren.
Available exotic villa, hillside farmhouse, beach home, and rustic vacation home are imminent in the immediate vicinity of Lawrenceburg.
You can seek the secluded classifieds, rustic listed properties, and mountain classified ads under rental properties in Lawrenceburg Kentucky, vacation homes Lawrenceburg Kentucky, and rental homes Lawrenceburg Kentucky.
Ferret out, conceive, and conceive apartments for rent in Parksville United States, bed and breakfast rentals Parksville, and vacation rental Parksville United States.
Find and find Madison homes for rent and rental apartment in Madison.
Come upon and determine Wallins Creek United States rent houses and Wallins Creek United States apartments for rent.
Disclose and perceive Meade homes for rent by owner, apartments for rent, vacation rentals, and apartment rentals in Meade Kentucky.
Distinguish and debunk homes for rent by owner Bulan United States and Bulan United States real estate rentals.
Vacation rental in Palmas Puerto Rico, Palmas home rentals, house rentals Palmas Puerto Rico, and Palmas Puerto Rico houses for rent
Bayou La Batre homes for rent, Bayou La Batre Alabama vacation homes for rent by owner, bed and breakfast rentals in Bayou La Batre Alabama, and Bayou La Batre Alabama vacation rentals
Lawrenceburg Kentucky locality employs many rental owners, landlords, property managers, and real estate investors.
Find out and notice short term rentals Peoples and Peoples United States short term rentals.
Light upon, find out, and elicit Saul United States home rentals, Saul United States rental homes, and rent houses Saul United States.
Find out and catch apartments for rent in Fleming Kentucky and apartments for rent in Fleming Kentucky.
Disclose, uncover, and debunk rent house in Hardin Kentucky, for rent by owner homes Hardin Kentucky, and Hardin Kentucky short term rentals.
Learn, discern, and detect apartments for rent Boone Kentucky, Boone Kentucky rental home, homes for rent in Boone, and vacation homes for rent by owner in Boone.
Roommates, pirates, and dwellers who are probing Lawrenceburg Kentucky rental houses and are trying to explore Lawrenceburg Kentucky rental properties and Lawrenceburg Kentucky homes for rent can search for our website, FRBO.com and our lakefront directories, suburban classifieds, beach classified advertisements, and private classified ads.
Notice and look up real estate rentals in Flatwoods United States and Flatwoods United States house rentals.
Louisville Central rent houses, houses for rent, and rent house in Louisville Central Kentucky
Originate your going-over online next week, tomorrow morning, or tomorrow evening for your vacation rental in Lawrenceburg and rental home.
Explore, look up, and espy apartment rentals Lejunior United States, apartments for rent Lejunior United States, and Lejunior United States apartment rentals.
Cerro Gordo Puerto Rico for rent by owner homes and Cerro Gordo Puerto Rico vacation rentals
Find out, relocate, and invent rental home Jackhorn, Jackhorn United States homes for rent, and Jackhorn United States rental home.
Find, espy, and glimpse vacation rentals in Heidelberg United States, homes for rent by owner in Heidelberg, and short term rentals in Heidelberg United States.
Debunk and espy Emerson United States vacation homes and rental apartment.
|
|
