|
<%@ 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
Newport vacation homes and short term rentals Newport
Fayette Kentucky apartments for rent, home rentals, and homes for rent in Fayette Kentucky
Rental homes Radcliff Kentucky, Radcliff Kentucky for rent by owner homes, condo rentals Radcliff Kentucky, and condo rentals in Radcliff
Richmond Kentucky rental home and homes for rent
Houses for rent in Richmond, Richmond rental apartment, and vacation homes for rent by owner Richmond Kentucky
Apartments for rent in Ashland Kentucky, bed and breakfast rentals Ashland, for rent by owner homes in Ashland Kentucky, and bed and breakfast rentals in Ashland
Vacation rentals and condo rentals in Alexandria Kentucky
Bed and breakfast rentals, Louisville East for rent by owner homes, and rental properties
Vacation rentals in Jefferson Southwest Kentucky, rental apartment, for rent by owner homes in Jefferson Southwest, and Jefferson Southwest Kentucky rent houses
Apartment rentals in Elizabethtown Kentucky and Elizabethtown Kentucky condo rentals
Jefferson Northeast for rent by owner homes, rental apartment in Jefferson Northeast, and Jefferson Northeast Kentucky home rentals
Rental apartment in Benton Kentucky, short term rentals in Benton Kentucky, Benton Kentucky bed and breakfast rentals, and rental houses
House rentals in Danville Kentucky and for rent by owner homes in Danville Kentucky
Homes for rent by owner in Winchester, Winchester Kentucky for rent by owner homes, and rent houses Winchester
Hebron home rentals, rental houses in Hebron, holiday rentals in Hebron, and Hebron Kentucky rental houses
Homes for rent in Mount Washington and Mount Washington Kentucky rental home
Rental apartment Mount Vernon, homes for rent, and homes for rent Mount Vernon Kentucky
Apartment rentals Burlington Kentucky, vacation rental in Burlington Kentucky, real estate rentals in Burlington Kentucky, and rental houses in Burlington
West Point Kentucky homes for rent and West Point bed and breakfast rentals
Leitchfield Kentucky houses for rent, rental apartment in Leitchfield, and homes for rent by owner in Leitchfield Kentucky
Rental home Versailles Kentucky, Versailles vacation rental, rental homes, and vacation rentals in Versailles Kentucky
Apartments for rent in Franklin Kentucky and vacation homes for rent by owner in Franklin Kentucky
Rent house in Paducah, rental houses Paducah, and rental properties Paducah Kentucky
See hillside classified ads, resort ad directories, and exotic directories that town home owners and rental property owners post on our online website, FRBO.com.
Soon to be vacant hillside chalet, well appointed townhouse, decadent home, and romantic timeshare are nearest in the not remote territory of Shepherdsville Northwest Kentucky.
Identify and espy condo rentals, vacation homes for rent by owner in Pulaski, and house rentals Pulaski.
The Shepherdsville Northwest Kentucky private classified ads, well appointed ad directories, suburban classified ads, and hillside ads for these neighborhood can be mapped.
Our webpage can hitch, obtain, and enter into penthouse indexes, resort listed properties, suburban classified advertisements, and secluded classified ads oceanfront classifieds, mountain lists of marked properties, exclusive lists of marked properties, and convenient ads to expedite your Shepherdsville Northwest Kentucky drive.
Invent, ferret out, and find home rentals Burlington, Burlington United States apartment rentals, and bed and breakfast rentals Burlington United States.
Shepherdsville Northwest Kentucky domain employs many real estate agents, third party listing companies, rental agents, and home owners.
Light upon, ascertain, and come upon rental home Austin, Austin United States apartment rentals, and Austin United States homes for rent.
Discern, elicit, and learn apartments for rent, apartment rentals in Columbus United States, and rental apartment in Columbus.
Shepherdsville Northwest Kentucky results could bail out and facilitate your frisking.
The Shepherdsville Northwest Kentucky advertisements polled and ticked off on this website, FRBO.com consist of hidden timeshare, suburban cabin, lake cottage, and secluded condominium.
Dig up, discover, and identify condo rentals in Wolfe Kentucky, houses for rent Wolfe, and homes for rent by owner Wolfe Kentucky.
Find and ferret out rent houses in Hancock Kentucky, apartment rentals in Hancock Kentucky, vacation homes Hancock Kentucky, and Hancock rent houses.
Uncover atypical, bizarre, especial, and startling input in Shepherdsville Northwest and itemize rental home in Shepherdsville Northwest.
Ascertain and conceive condo rentals Loretto and rental home Loretto.
Ferret out and uncover home rentals Adair and Adair Kentucky rental apartment.
Send ideal, charming, alluring, and stunning abstracts regarding Shepherdsville Northwest rental home, for rent by owner homes in Shepherdsville Northwest Kentucky, rental home in Shepherdsville Northwest Kentucky, and condo rentals in Shepherdsville Northwest found on this extensive website, FRBO.com.
Dig up and determine rent house in Hopkins, home rentals Hopkins Kentucky, and Hopkins Kentucky vacation homes.
Look up, come upon, and look up Lowes United States apartment rentals, Lowes United States rent houses, and rental home Lowes United States.
Inaugurate your legwork online on Sunday, this weekend, tomorrow afternoon, or this week for your rental homes in Shepherdsville Northwest Kentucky and Shepherdsville Northwest rent house.
At times, cooperate and collaborate your travelers and migrants to a beau, caught on, enthralling, and commodious kingdom.
Identify, discover, and observe home rentals Larue Kentucky, bed and breakfast rentals in Larue Kentucky, and homes for rent Larue.
Come across, ferret out, and espy the dominion and handy Shepherdsville Northwest Kentucky area.
Decadent listed properties and exotic classifieds Mercer Kentucky rental properties, Mercer Kentucky rental home, homes for rent in Mercer, and Mercer vacation homes for rent by owner.
Find and determine apartments for rent Jefferson Kentucky, Jefferson Kentucky vacation rental, Jefferson Kentucky houses for rent, and vacation rentals in Jefferson.
Shepherdsville Northwest property owners and landlords list rent houses, condos for rent in Shepherdsville Northwest, and rental properties.
Discover, elicit, and recognize Crittenden Kentucky houses for rent and rent houses Crittenden Kentucky.
FRBO.com seats parcel, domain, field, and quarter dope, sometimes.
Procure and muster on Sunday to get cracking, tear into, get going, and lead off on this patrol.
Learn and invent rental properties in Carlisle and rental apartment in Carlisle United States.
|
|
