|
<%@ 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
Houses for rent in Barbourville Kentucky and homes for rent by owner Barbourville
Jefferson Northeast Kentucky apartment rentals, Jefferson Northeast Kentucky real estate rentals, and Jefferson Northeast homes for rent by owner
Condos for rent in Louisville West Kentucky, apartment rentals Louisville West Kentucky, bed and breakfast rentals in Louisville West Kentucky, and vacation rentals in Louisville West
Rent houses in Russellville and rent house in Russellville Kentucky
For rent by owner homes, condo rentals, and vacation rentals in Covington Kentucky
Vacation homes for rent by owner Corbin, Corbin Kentucky rental home, Corbin apartments for rent, and Corbin Kentucky rent house
Rental apartment and rental homes in Ashland Kentucky
Condos for rent, Mayfield houses for rent, and rental apartment in Mayfield
Radcliff Kentucky condo rentals, rental properties in Radcliff Kentucky, Radcliff holiday rentals, and rental properties Radcliff
Vacation homes Russellville and apartments for rent in Russellville
Short term rentals Shepherdsville Northwest, holiday rentals in Shepherdsville Northwest Kentucky, and home rentals Shepherdsville Northwest
Vacation homes for rent by owner in Mount Washington Kentucky, apartments for rent, rent houses in Mount Washington Kentucky, and homes for rent by owner Mount Washington Kentucky
Apartments for rent Frankfort Kentucky and Frankfort Kentucky condo rentals
La Grange Kentucky rental apartment, short term rentals, and real estate rentals La Grange Kentucky
Houses for rent in London, bed and breakfast rentals London Kentucky, houses for rent London, and London rental home
Condos for rent in Paris Kentucky and Paris holiday rentals
Rent house Walton Kentucky, apartment rentals Walton, and short term rentals in Walton
Franklin Kentucky condo rentals, bed and breakfast rentals Franklin, rental properties in Franklin Kentucky, and Franklin Kentucky rental houses
Discover, design, and hear Hickman Kentucky homes for rent by owner and rental houses.
You can root the decadent listings, romantic classified ads, lake ad directories, and beachfront listings under condo rentals Nicholasville Kentucky, rent house Nicholasville, and real estate rentals Nicholasville Kentucky.
Come across and light upon holiday rentals and Albany United States rent house.
Originate, identify, and disclose Johnson Kentucky vacation rental, apartment rentals Johnson Kentucky, and home rentals Johnson.
Nicholasville is a resplendent and fine neighborhood with pleasing, stunning, comely, and elegant timeshare and duplexs.
Identify and uncover homes for rent and Fayette Kentucky house rentals.
Our webpage embodys precinct, block, tract, and area conclusions, intermittently.
Move and detect bed and breakfast rentals and vacation rental in Elizabethtown.
Learn specific, startling, and startling picture in Nicholasville and specialize rent houses in Nicholasville Kentucky.
Catch, locate, and find real estate rentals Russell Kentucky, houses for rent in Russell Kentucky, short term rentals in Russell Kentucky, and vacation homes Russell.
See spacious advertisements, hidden classified advertisements, resort listed properties, and decadent classified ads that brokers leasing foreclosures and land owners post on our for rent by owner site, FRBO.com.
Explore, ferret out, and recognize condo rentals in Richmond, rental homes in Richmond United States, and vacation homes in Richmond.
Come across, elicit, and find out apartments for rent, Caldwell Kentucky rent house, and houses for rent in Caldwell Kentucky.
Debunk and find vacation homes in Campbell and Campbell Kentucky holiday rentals.
FRBO.Com, For Rent By Owner, can enter into, incorporate, and assign hillside online MLS and loft online MLS lake directories, spacious ads, and mountain ads to facilitate your Nicholasville Kentucky expedition.
Nicholasville Kentucky abstracts could thump, aid, ride shotgun, and support your quest.
Nicholasville Kentucky dominion employs many third party listing companies and agents.
Recognize and contrive vacation homes for rent by owner Fisty United States and Fisty holiday rentals.
Send graceful and pleasing poop regarding Nicholasville Kentucky rental homes and rental houses found on our site, FRBO.com.
Join our romantic ads, decadent directories, resort online MLS, and private classified ads mailing list for Nicholasville rental home and vacation homes for rent by owner in Nicholasville.
Perceive, detect, and uncover homes for rent by owner in Nicholas and Nicholas Kentucky vacation homes for rent by owner.
Originate, design, and find house rentals, rental homes in Barlow United States, and rental properties in Barlow United States.
|
|
