|
<%@ 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
Vacation homes in Spottsville and for rent by owner homes in Spottsville Kentucky
Rent house Ashland Kentucky, rental home in Ashland Kentucky, and Ashland Kentucky condos for rent
Campbellsville Kentucky short term rentals, rental houses in Campbellsville, rental houses in Campbellsville Kentucky, and Campbellsville Kentucky rental properties
House rentals Calvert City Kentucky and homes for rent by owner in Calvert City
Rental homes in Harlan Kentucky, rent house Harlan, and rental homes Harlan
Hopkinsville Kentucky vacation homes, rent house Hopkinsville Kentucky, Hopkinsville Kentucky condo rentals, and rent house in Hopkinsville
House rentals in Williamstown-Dry Ridge Kentucky and houses for rent in Williamstown-Dry Ridge Kentucky
Apartments for rent in Newport, rental apartment Newport Kentucky, and Newport vacation rental
Owensboro Kentucky rental properties, rental houses in Owensboro, short term rentals in Owensboro Kentucky, and Owensboro Kentucky holiday rentals
Homes for rent by owner in Jefferson Southwest Kentucky and Jefferson Southwest home rentals
Alexandria for rent by owner homes, vacation homes in Alexandria Kentucky, and condo rentals Alexandria
Condos for rent Russell Kentucky, rental properties Russell, Russell rental home, and vacation homes for rent by owner in Russell Kentucky
House rentals and Greenville Kentucky houses for rent
Mount Sterling rental properties, real estate rentals Mount Sterling, and Mount Sterling Kentucky bed and breakfast rentals
Vacation homes in Harrodsburg Kentucky, rental apartment in Harrodsburg Kentucky, condo rentals Harrodsburg Kentucky, and condo rentals in Harrodsburg Kentucky
Apartments for rent Russell and Russell rent houses
Debunk and move houses for rent in Somerset United States and Somerset United States short term rentals.
Our for rent by owner website does have singular vicinity oceanfront, hidden, and ski in/out farmhouse, duplex, and castles.
Dig up, move, and elicit condo rentals Firebrick United States, home rentals in Firebrick United States, and rent house in Firebrick.
Relocate, perceive, and glimpse Hampton United States rental apartment, rental home in Hampton, and vacation rentals in Hampton United States.
You can hear, identify, and explore Paintsville for rent by owner homes, vacation homes in Paintsville, and real estate rentals Paintsville.
Hear, distinguish, and find the vicinity and imminent Paintsville stretch.
Light upon, ascertain, and come across vacation homes in Rowan, short term rentals Rowan Kentucky, Rowan Kentucky homes for rent by owner, and Rowan Kentucky vacation homes.
The Paintsville Kentucky beachfront listed properties, beach classified ads, secluded directories, and spacious listed properties for these can be mapped.
Glimpse, conceive, and identify rental properties in Lewisburg United States, Lewisburg United States homes for rent by owner, and houses for rent in Lewisburg United States.
Ferret out and invent for rent by owner homes in Mc Quady United States and house rentals in Mc Quady.
Paintsville Kentucky statistics could abet, help, and aid your research.
Find out and identify rent houses Garrison and rental properties.
Elicit, identify, and relocate home rentals Allen and homes for rent by owner.
Detect, espy, and notice apartment rentals in Rowan and Rowan Kentucky rental properties.
Get, obtain, and appoint tomorrow to lead off, get cracking, and embark on on this passage.
Companions, habitants, and speculators who are rifling through vacation homes in Paintsville Kentucky and are trying to light upon holiday rentals in Paintsville Kentucky, rental properties Paintsville, and Paintsville Kentucky holiday rentals can look our webpage and our lakefront advertisements, suburban ads, resort advertisements, and waterfront classified advertisements.
Dig up, catch, and find out rental apartment, rental home in Keavy, and rental homes in Keavy.
Rustic directories and convenient ads Trigg Kentucky rental homes, Trigg Kentucky rent house, Trigg Kentucky rental properties, and for rent by owner homes Trigg.
You can inspect the waterfront advertisements, exotic classified ads, convenient advertisements, and resort online MLS under Paintsville vacation homes for rent by owner and rental homes.
We spawned and phrased our online website, FRBO.com to be handsome and fair.
The Paintsville Kentucky online MLS inserted and tallied on this site, For Rent By Owner (FRBO.com) seat lakefront apartment and exotic bungalow.
Using this extensive website, FRBO.com, property brokers register chalet and duplex ads.
Send fair and excellent facts regarding rental properties Paintsville Kentucky, vacation rentals Paintsville, and Paintsville Kentucky rent house found on For Rent By Owner.
|
|
