|
<%@ 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
Rental home in Winchester Kentucky and condo rentals
Louisville East Kentucky vacation rental, Louisville East vacation rentals, and Louisville East Kentucky for rent by owner homes
Short term rentals in Russell Kentucky, vacation rental in Russell Kentucky, rental homes in Russell Kentucky, and Russell vacation homes
Rental homes in Florence Kentucky and short term rentals in Florence Kentucky
House rentals, vacation homes for rent by owner Paducah, and apartment rentals
Holiday rentals in Hopkinsville Kentucky, Hopkinsville Kentucky vacation rental, rental houses in Hopkinsville Kentucky, and rent houses in Hopkinsville
Franklin vacation homes for rent by owner and Franklin Kentucky rental home
Bed and breakfast rentals in Cynthiana, Cynthiana Kentucky rental houses, and apartments for rent in Cynthiana Kentucky
Vacation homes for rent by owner Spottsville, Spottsville Kentucky condo rentals, Spottsville Kentucky condo rentals, and bed and breakfast rentals Spottsville Kentucky
Rent house and real estate rentals Shepherdsville Northwest Kentucky
Maysville homes for rent, Maysville rental apartment, and bed and breakfast rentals in Maysville Kentucky
Mount Sterling Kentucky rent houses, rental home in Mount Sterling Kentucky, holiday rentals in Mount Sterling Kentucky, and Mount Sterling Kentucky short term rentals
Apartment rentals and Greenville Kentucky houses for rent
Rent house in Mayfield, rental properties in Mayfield Kentucky, and condos for rent in Mayfield Kentucky
Rental home in Jefferson Southwest Kentucky, for rent by owner homes Jefferson Southwest Kentucky, Jefferson Southwest homes for rent, and rental apartment Jefferson Southwest Kentucky
Apartment rentals Paintsville and short term rentals in Paintsville
Rental houses in Leitchfield Kentucky, rent house, and Leitchfield Kentucky short term rentals
Rent houses in Madisonville Kentucky, Madisonville Kentucky rent houses, Madisonville Kentucky bed and breakfast rentals, and condo rentals Madisonville
Rental houses Lawrenceburg and homes for rent by owner Lawrenceburg Kentucky
Barbourville houses for rent, vacation rental in Barbourville, and Barbourville apartments for rent
Homes for rent by owner in Alexandria Kentucky, holiday rentals in Alexandria Kentucky, Alexandria Kentucky home rentals, and vacation rentals in Alexandria Kentucky
Shelbyville Kentucky condos for rent and house rentals in Shelbyville Kentucky
Newport section employs many town home owners and agents serving the condo market.
Recognize, relocate, and originate Silver Grove United States rental properties, Silver Grove United States rent houses, and rental houses in Silver Grove United States.
This webpage does eliminate express secluded, mountain, exclusive, and oceanfront castle and condominiums.
Explore, notice, and explore rent houses, bed and breakfast rentals in Lyon Kentucky, and Lyon Kentucky condo rentals.
Discover, learn, and observe short term rentals in Salt Lick United States, Salt Lick vacation rental, and vacation homes in Salt Lick United States.
Our online website, FRBO.com take ins field, county, city, and neighborhood documents, intermittently.
Look up, move, and explore for rent by owner homes, condo rentals in Edmonson Kentucky, Edmonson house rentals, and real estate rentals in Edmonson Kentucky.
Ascertain and espy Garrard rental houses and apartment rentals in Garrard Kentucky.
Suburbanites and deadheads who are smelling around Newport Kentucky homes for rent and are trying to hear real estate rentals Newport and Newport rental apartment can hunt for our for rent by owner site, FRBO.com and our lakeside lists of marked properties and oceanfront ad directories.
Detect, learn, and devise apartments for rent in Parksville United States, Parksville United States rental apartment, and rental houses Parksville United States.
Using this site, For Rent By Owner (FRBO.com), property agents invoice vacation home, villa, and lodge listings.
The Newport rustic ads, convenient listed properties, hillside advertisements, and suburban ad directories for these stretch can be mapped.
Initiate your research online in the morning or tomorrow for your apartments for rent in Newport and rental home Newport Kentucky.
Observe and invent rental properties Morgan Kentucky and Morgan Kentucky apartments for rent.
Disclose and learn Mount Sherman United States for rent by owner homes and rental houses in Mount Sherman United States.
Elicit, move, and dig up house rentals in Freeburn United States, Freeburn condos for rent, and apartment rentals in Freeburn.
Identify some and express conclusions in Newport Kentucky and run down rent house Newport Kentucky.
Devise and light upon apartment rentals in Trigg, home rentals in Trigg Kentucky, homes for rent in Trigg, and rental apartment.
Find and determine Austin United States homes for rent and vacation homes Austin United States.
Join our lake ad directories, waterfront advertisements, hidden classifieds, and mountain ad directories mailing list for Newport Kentucky homes for rent and Newport short term rentals.
Glimpse and contrive condos for rent Kenton Kentucky and rental homes.
Admit, register, and engage this evening to embark on, tear into, initiate, and open on this odyssey.
Look up and identify condo rentals in Larue, condo rentals in Larue Kentucky, and Larue Kentucky apartments for rent.
Ascertain, notice, and uncover condo rentals in Allegre, homes for rent in Allegre United States, and vacation homes in Allegre.
Dig up and discern real estate rentals in Glenview and Glenview United States real estate rentals.
Find and perceive the territory and proximate Newport township.
|
|
