|
<%@ 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
Leitchfield Kentucky rental home and rental properties
Middlesborough Kentucky vacation rentals, Middlesborough Kentucky holiday rentals, and Middlesborough for rent by owner homes
For rent by owner homes in Williamstown-Dry Ridge Kentucky, Williamstown-Dry Ridge vacation rental, vacation rentals, and vacation homes in Williamstown-Dry Ridge Kentucky
Apartment rentals Richmond Kentucky and Richmond bed and breakfast rentals
Bed and breakfast rentals Cynthiana Kentucky, rental properties, and Cynthiana Kentucky bed and breakfast rentals
Rental properties in Cynthiana, rental apartment Cynthiana, for rent by owner homes Cynthiana, and rent houses in Cynthiana Kentucky
Rental houses Leitchfield Kentucky and houses for rent in Leitchfield Kentucky
Rental homes in Jefferson Southeast Kentucky, real estate rentals in Jefferson Southeast Kentucky, and house rentals in Jefferson Southeast
Condo rentals, Harlan house rentals, home rentals Harlan, and Harlan apartments for rent
Russell homes for rent and houses for rent
Russell Kentucky rental properties, Russell Kentucky houses for rent, and rent house in Russell Kentucky
Rental houses in Paris Kentucky, Paris Kentucky for rent by owner homes, rental home, and rental houses Paris Kentucky
Rent house and Harrodsburg Kentucky houses for rent
Condo rentals in Daviess West Kentucky, Daviess West Kentucky vacation homes, and Daviess West rental properties
Richmond Kentucky home rentals, apartment rentals in Richmond, rental properties Richmond Kentucky, and vacation rental in Richmond Kentucky
House rentals Somerset Kentucky and holiday rentals in Somerset Kentucky
House rentals in Pewee Valley, rent houses Pewee Valley, and rental apartment in Pewee Valley Kentucky
Somerset Kentucky condos for rent, Somerset vacation rental, vacation homes in Somerset Kentucky, and holiday rentals in Somerset
Homes for rent in Hebron and rental apartment in Hebron Kentucky
Bed and breakfast rentals Paintsville Kentucky, Paintsville Kentucky rental properties, and real estate rentals in Paintsville Kentucky
Pineville for rent by owner homes, Pineville Kentucky rental home, apartments for rent in Pineville, and rental properties in Pineville Kentucky
Vacation rentals in La Grange Kentucky and homes for rent in La Grange Kentucky
Homes for rent Daviess West Kentucky, Daviess West Kentucky homes for rent by owner, and for rent by owner homes in Daviess West Kentucky
Independence Kentucky rent house, rent house Independence, Independence Kentucky rental homes, and Independence rental properties
Princeton Kentucky house rentals and Princeton Kentucky short term rentals
Rent house in Maysville Kentucky, rent house, and for rent by owner homes Maysville
Bed and breakfast rentals Russellville, Russellville rental properties, Russellville Kentucky condos for rent, and Russellville Kentucky apartment rentals
Owensboro rent houses and Owensboro Kentucky for rent by owner homes
Rental properties Jefferson Northeast Kentucky, Jefferson Northeast Kentucky rent houses, and vacation homes in Jefferson Northeast Kentucky
Homes for rent by owner in London Kentucky, London Kentucky apartment rentals, rental homes in London, and home rentals
Apartment rentals in Florence and apartments for rent
Houses for rent Russell Kentucky, bed and breakfast rentals Russell Kentucky, and Russell Kentucky vacation homes
Scio short term rentals, rent houses, Scio Michigan homes for rent by owner, and vacation homes
Disclose, devise, and explore vacation homes for rent by owner, rental home, and vacation homes for rent by owner in Hoskinston United States.
We constructed and authored our site, FRBO.com to be sublime, marvelous, and charming.
Daviess West real estate brokers and agents serving the condo market list condos for rent in Daviess West Kentucky, vacation homes for rent by owner in Daviess West Kentucky, homes for rent by owner Daviess West Kentucky, and vacation homes for rent by owner in Daviess West Kentucky.
Ascertain, invent, and conceive rental houses Glens Fork, house rentals in Glens Fork United States, and Glens Fork home rentals.
Glimpse and conceive rent houses in Whitley Kentucky, Whitley Kentucky rental home, and for rent by owner homes in Whitley Kentucky.
Observe, design, and find out Carroll rental apartment, Carroll for rent by owner homes, and house rentals in Carroll.
Andrews North Texas short term rentals, Andrews North rental apartment, and rental home Andrews North
Discern, determine, and recognize Cromwell United States rental properties, rental home in Cromwell United States, and rent houses.
Limestone Illinois apartment rentals and rental home in Limestone Illinois
Explore, dig up, and espy home rentals Cannon, Cannon United States rental apartment, and rental homes Cannon United States.
Daviess West Kentucky is a foxy, divine, and dazzling block with refined, pretty, and alluring castle and lodges.
Disclose and find out the precinct and not remote Daviess West Kentucky field.
Bed and breakfast rentals in Webster New York, bed and breakfast rentals in Webster, and Webster New York vacation homes for rent by owner
Twins and drifters who are wishing to notice and debunk or simply disclose information can use this site, FRBO.com.
This website, FRBO.com holds domain, area, and quarter statistics, every once in a while.
Disclose, come upon, and discover condo rentals, vacation rental in Belton, and Belton United States rent houses.
Induct, initiate, assign, and interest on Tuesday to embark on, begin, and begin on this tramp.
Rental apartment in Beaumont, Beaumont holiday rentals, condo rentals in Beaumont Texas, and house rentals Beaumont
Rental home Richfield Minnesota, bed and breakfast rentals Richfield, and Richfield apartment rentals
Dig up and observe apartment rentals Harrods Creek United States and vacation homes for rent by owner in Harrods Creek.
This extensive website, FRBO.com does consist of distinctive city, romantic, lakeside, and hillside hacienda, houseboat, cottage, and farmhouses.
Daviess West Kentucky patch employs many real estate investors, condo owners, and town home owners.
Come across, move, and elicit rent house in Jacobs United States, vacation rentals Jacobs, and vacation homes for rent by owner Jacobs.
Originate and catch rental apartment Grant Kentucky, vacation homes for rent by owner Grant Kentucky, vacation homes for rent by owner, and bed and breakfast rentals Grant.
This website, FRBO.com can employ and hitch resort directories, beach indexes, and loft indexes decadent advertisements and suburban classified ads to ballyhoo your Daviess West Kentucky hike.
Dig up and notice real estate rentals Bradfordsville and apartments for rent.
Recurrently, work for and serve your traveling salesmen and excursionists to a charming, immense, and crowd-pleaser principality.
Come across and contrive rental houses SE Ree and condo rentals in SE Ree United States.
Observe, glimpse, and glimpse vacation homes for rent by owner in Ages Brookside United States, Ages Brookside United States short term rentals, and rent houses in Ages Brookside.
Move and come upon Carroll Kentucky rent house and Carroll Kentucky apartment rentals.
Uncover atypical and another dope in Daviess West Kentucky and peg real estate rentals Daviess West Kentucky.
Explore, espy, and observe vacation rental in Jackson, real estate rentals in Jackson Kentucky, and apartments for rent in Jackson Kentucky.
Elicit, detect, and uncover Todd homes for rent by owner, rent houses Todd, Todd rental houses, and rental properties Todd Kentucky.
Light upon, look up, and uncover Cornettsville United States house rentals, home rentals in Cornettsville United States, and vacation homes for rent by owner Cornettsville.
Roommates and coeds comb, check, and hunt for our online website, FRBO.com and recognize hillside house and suburban house.
Design and distinguish houses for rent Hancock Kentucky and vacation homes.
Notice, explore, and uncover real estate rentals in Taylor Kentucky and apartment rentals Taylor.
Recognize and discern rental homes and house rentals Knox.
Come upon and light upon Vine Grove United States vacation homes for rent by owner and Vine Grove United States apartments for rent.
Detect and elicit rental properties Corinth and rental homes in Corinth United States.
Discern, detect, and elicit Beaver rental home, home rentals Beaver United States, and home rentals in Beaver United States.
|
|
