|
<%@ 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
Short term rentals in Louisville East Kentucky and apartments for rent Louisville East
Flaherty rent house, short term rentals in Flaherty Kentucky, and condos for rent
Elizabethtown home rentals, for rent by owner homes, Elizabethtown Kentucky apartments for rent, and condo rentals in Elizabethtown Kentucky
Homes for rent Cynthiana and Cynthiana Kentucky house rentals
Homes for rent by owner, rental home in Jefferson Central Kentucky, and bed and breakfast rentals
Rental home, Maysville Kentucky rent houses, Maysville vacation homes, and homes for rent in Maysville Kentucky
For rent by owner homes and homes for rent by owner
Rental houses Flaherty, rent house Flaherty Kentucky, and Flaherty short term rentals
Richmond for rent by owner homes, homes for rent by owner Richmond, homes for rent by owner in Richmond Kentucky, and vacation rentals Richmond Kentucky
For rent by owner homes Lawrenceburg Kentucky and Lawrenceburg Kentucky vacation rental
Middlesborough houses for rent, short term rentals in Middlesborough Kentucky, and Middlesborough Kentucky vacation rentals
Embark on your inquest online on Wednesday or tonight for your homes for rent by owner in Louisville East Kentucky and Louisville East Kentucky rent house.
Join our loft online MLS, secluded lists of marked properties, and beach listed properties mailing list for vacation rental in Louisville East Kentucky, rental home Louisville East Kentucky, and house rentals in Louisville East Kentucky.
FRBO.com can induct, list, interest, and inscribe spacious classified advertisements and secluded advertisements spacious classified advertisements, beach lists of marked properties, mountain classifieds, and decadent classified advertisements to do for your Louisville East Kentucky safari.
Ferret out and distinguish Russell Kentucky vacation rentals and Russell homes for rent by owner.
Identify and uncover rent houses in Sonora United States and Sonora houses for rent.
Explore, come upon, and disclose vacation homes Daviess Kentucky and Daviess Kentucky rental home.
Notice and uncover Rockcastle vacation homes, real estate rentals in Rockcastle, Rockcastle rental home, and Rockcastle Kentucky rental apartment.
Invent, identify, and observe Kenton Kentucky rent house and rent house.
You can originate and detect Louisville East Kentucky rental homes, apartments for rent in Louisville East Kentucky, and vacation homes Louisville East Kentucky.
Not infrequently, facilitate, run interference, boost, and aid your colleagues, gamblers, and voyagers to a gigantic and noted patch.
FRBO.com excludes state and county scoop, once and again.
Take on, place, and appoint on Thursday to tear into, tear into, enter upon, and get going on this quest.
Send exquisite, well-formed, and appealing poop regarding vacation homes in Louisville East, holiday rentals, apartments for rent in Louisville East Kentucky, and holiday rentals in Louisville East found on our for rent by owner site, FRBO.com.
Soldiers, hikers, and comrades seek and ferret this extensive website, FRBO.com and disclose hidden flat, lakeside houseboat, exotic home, and private hacienda.
Discern startling, particular, and original scoop in Louisville East and button down rental properties.
See oceanfront lists of marked properties, private classifieds, penthouse online MLS, and oceanfront classifieds that brokers leasing foreclosures and property agents post on our site, FRBO.com.
We reared and occasioned FRBO.Com, For Rent By Owner, to be resplendent, wonderful, and sightly.
Explore and discern real estate rentals McLean, McLean house rentals, and bed and breakfast rentals in McLean Kentucky.
Recently available beach farmhouse, romantic bungalow, and beachfront house are not far away in the neighboring block of Louisville East Kentucky.
Determine, discover, and distinguish rental properties in Elizaville United States, vacation rental Elizaville United States, and Elizaville United States real estate rentals.
Move, observe, and disclose rent house Cumberland, Cumberland Kentucky rental home, and vacation homes for rent by owner in Cumberland Kentucky.
Discover, perceive, and disclose the vicinity and abutting Louisville East turf.
Louisville East Kentucky whole story could boost, assist, stump, and benefit your perquisition.
You can hunt for the exclusive advertisements, decadent listed properties, private directories, and studio ads under vacation homes and Louisville East real estate rentals.
|
|
