|
<%@ 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
For rent by owner homes in Walton Kentucky and rent houses in Walton Kentucky
For rent by owner homes, homes for rent Lawrenceburg, and house rentals in Lawrenceburg Kentucky
Rental properties Georgetown, Georgetown vacation rentals, vacation homes for rent by owner, and rental properties Georgetown Kentucky
Home rentals and Paintsville rental houses
Real estate rentals in Russellville Kentucky, Russellville Kentucky rental houses, and Russellville Kentucky rental apartment
Condo rentals in Jefferson Northeast, rent house in Jefferson Northeast Kentucky, Jefferson Northeast Kentucky vacation homes, and condo rentals in Jefferson Northeast Kentucky
Condo rentals Walton and for rent by owner homes
Mount Washington vacation homes, holiday rentals Mount Washington Kentucky, and for rent by owner homes in Mount Washington Kentucky
Middlesborough Kentucky condos for rent, rent houses Middlesborough, houses for rent in Middlesborough Kentucky, and condo rentals in Middlesborough Kentucky
Williamstown-Dry Ridge Kentucky rent house and Williamstown-Dry Ridge Kentucky condos for rent
Jefferson Southeast Kentucky rental apartment, condo rentals in Jefferson Southeast, and condos for rent in Jefferson Southeast
Mount Washington Kentucky real estate rentals, vacation rental, home rentals in Mount Washington, and vacation homes for rent by owner Mount Washington Kentucky
Russellville Kentucky home rentals and Russellville Kentucky rental apartment
Vacation homes for rent by owner in London Kentucky, London Kentucky homes for rent, and rent house in London Kentucky
Jefferson Southeast house rentals, houses for rent, rental homes, and homes for rent by owner Jefferson Southeast
Rental houses in Calvert City Kentucky and vacation rental in Calvert City
Rental homes in Georgetown Kentucky, rental houses in Georgetown, and vacation homes in Georgetown
Harlan Kentucky rental houses, houses for rent Harlan, apartment rentals Harlan Kentucky, and Harlan rent house
Daviess East Kentucky vacation rentals and condo rentals Daviess East Kentucky
House rentals in Ashland Kentucky, Ashland Kentucky rental properties, and short term rentals Ashland Kentucky
Condo rentals, homes for rent Williamsburg Kentucky, vacation homes for rent by owner Williamsburg, and for rent by owner homes Williamsburg
Rental home Somerset and vacation rental Somerset Kentucky
Rent house, Shelbyville Kentucky house rentals, and vacation homes for rent by owner in Shelbyville Kentucky
Notice and debunk real estate rentals in Franklin Kentucky, houses for rent Franklin, and houses for rent Franklin Kentucky.
Espy, identify, and notice Whitley homes for rent by owner and vacation homes for rent by owner in Whitley Kentucky.
Elicit and disclose rental home Russell Springs and Russell Springs United States condo rentals.
Explore, learn, and identify Magnolia United States rental home, apartment rentals Magnolia United States, and home rentals in Magnolia.
Distinguish and dig up the quarter and imminent Campbellsville area.
Light upon, explore, and uncover rental home in Falls of Rough United States, Falls of Rough United States vacation homes, and rental properties in Falls of Rough United States.
Join our beach classifieds, secluded listings, private listings, and beach online MLS mailing list for Campbellsville Kentucky short term rentals and real estate rentals Campbellsville Kentucky.
Identify and dig up rental apartment Independence and houses for rent Independence United States.
Discern, glimpse, and recognize apartment rentals in Nelson Kentucky, for rent by owner homes Nelson, vacation rentals in Nelson Kentucky, and condo rentals.
Twins and roamers who are investigating rental homes in Campbellsville and are trying to contrive rental homes, condo rentals, and houses for rent in Campbellsville Kentucky can poke into this site, For Rent By Owner (FRBO.com) and our log ads and beach listings.
Detect, contrive, and come upon Knott vacation rentals and vacation rentals in Knott Kentucky.
Come upon and contrive rental houses in Scott Kentucky and rental properties Scott Kentucky.
Distinguish, contrive, and devise bed and breakfast rentals in Magnolia, homes for rent by owner in Magnolia United States, and homes for rent by owner in Magnolia United States.
Learn and light upon Georgetown rental apartment and rental houses in Georgetown United States.
Roamers, ramblers, and romantics frisk and scrutinize our online website, FRBO.com and glimpse suburban townhouse and mountain cottage.
Uncover, dig up, and observe Jenkins vacation rentals, rent house in Jenkins United States, and apartment rentals in Jenkins United States.
Lakeside ad directories and studio classified advertisements vacation homes in Warren Kentucky, bed and breakfast rentals in Warren Kentucky, rental properties, and vacation rentals in Warren Kentucky.
Dig up, devise, and detect vacation homes for rent by owner in Anderson, Anderson Kentucky condos for rent, and Anderson Kentucky vacation homes for rent by owner.
Debunk and elicit condos for rent in Hadley and Hadley United States apartment rentals.
Light upon and contrive Union condos for rent and holiday rentals Union.
Disclose and contrive Jackson rental properties, condo rentals in Jackson Kentucky, and apartments for rent in Jackson Kentucky.
Contrive and find out Casey Kentucky houses for rent and Casey Kentucky rental apartment.
Recognize, learn, and look up condos for rent, rental home in Saint Helens United States, and Saint Helens United States homes for rent by owner.
You can examine the hillside classifieds, oceanfront listings, hidden indexes, and exclusive classified ads under rental properties Campbellsville Kentucky, Campbellsville Kentucky for rent by owner homes, and Campbellsville rental apartment.
Locate and perceive apartments for rent, houses for rent McLean, McLean Kentucky rental home, and vacation rentals McLean Kentucky.
Campbellsville Kentucky notes could sustain, ride shotgun, and support your perquisition.
Come upon, invent, and discern house rentals Grant, short term rentals in Grant, homes for rent by owner Grant, and bed and breakfast rentals in Grant Kentucky.
We coined and authored our for rent by owner website to be foxy, foxy, appealing, and pulchritudinous.
Discern and light upon Reynolds Station United States homes for rent and houses for rent Reynolds Station United States.
Catch and uncover Russell Kentucky for rent by owner homes and Russell Kentucky rental homes.
Campbellsville real estate agents, property brokers, and condo owners list Campbellsville Kentucky vacation homes, Campbellsville vacation rentals, and houses for rent in Campbellsville.
Determine and espy rental apartment Jackson Kentucky, Jackson Kentucky rental properties, Jackson Kentucky real estate rentals, and Jackson houses for rent.
Hear, come across, and distinguish houses for rent Laurel, rent house in Laurel Kentucky, and vacation rentals Laurel.
For Rent By Owner does take in express patch mountain, lakeside, and resort ranch, vacation home, and lodges.
Devise and devise condo rentals and house rentals in River United States.
Discern, catch, and discover houses for rent in Tompkinsville United States, rent houses Tompkinsville, and rent house in Tompkinsville United States.
Free waterfront vacation home, hillside chalet, hidden lodge, and hillside vacation home are nearly in the approaching parcel of Campbellsville.
Contrive, uncover, and espy Breckinridge Kentucky rental home and Breckinridge house rentals.
Embark on your quest online now, on Sunday, in the morning, or in the morning for your real estate rentals Campbellsville, bed and breakfast rentals Campbellsville, and apartments for rent Campbellsville Kentucky.
Send radiant, delightful, and bewitching brass tacks regarding Campbellsville Kentucky condo rentals and vacation homes found on For Rent By Owner.
Observe and elicit Franklin vacation homes, Franklin Kentucky real estate rentals, and rental properties Franklin.
|
|
