|
<%@ 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
Louisville Central Kentucky homes for rent and for rent by owner homes Louisville Central Kentucky
La Grange rent house, rent house in La Grange Kentucky, and homes for rent by owner La Grange
Holiday rentals in Franklin, Franklin Kentucky apartment rentals, Franklin Kentucky rental homes, and Franklin Kentucky rent house
Mount Sterling Kentucky houses for rent and vacation homes in Mount Sterling
Rental apartment in Berea, rental homes in Berea, and vacation homes for rent by owner Berea
Real estate rentals in Louisville South Kentucky, Louisville South Kentucky rent houses, vacation homes in Louisville South Kentucky, and rental properties in Louisville South Kentucky
Real estate rentals Henderson Kentucky and Henderson Kentucky real estate rentals
Vacation homes for rent by owner in Alexandria Kentucky, apartment rentals Alexandria Kentucky, and homes for rent in Alexandria
Vacation rentals Hebron, apartment rentals in Hebron, Hebron Kentucky vacation homes for rent by owner, and apartments for rent Hebron
Apartment rentals in Paducah Kentucky and condos for rent in Paducah Kentucky
Real estate rentals Danville, rent houses in Danville, and apartments for rent Danville
Look up and disclose vacation homes for rent by owner Hardin, Hardin Kentucky houses for rent, rental houses Hardin Kentucky, and rent house Hardin Kentucky.
Recognize, glimpse, and detect house rentals in Johnson Kentucky and vacation homes for rent by owner in Johnson Kentucky.
Jefferson Southwest Kentucky score could collaborate, plug, open doors, and ride shotgun your fishing expedition.
Ascertain, espy, and conceive Vanceburg United States condos for rent, Vanceburg United States rental properties, and Vanceburg United States homes for rent.
Send charming and elegant compilations regarding vacation rentals in Jefferson Southwest Kentucky, Jefferson Southwest Kentucky rental apartment, and apartments for rent in Jefferson Southwest found on For Rent By Owner.
Jefferson Southwest locality employs many land owners, agents serving the condo market, home owners, and real estate agents.
You can cast about the resort indexes, mountain classified ads, loft listings, and private indexes under Jefferson Southwest rent house and home rentals.
Espy, recognize, and come upon Firebrick rental apartment, for rent by owner homes in Firebrick United States, and Firebrick rental properties.
Hitch and obtain tomorrow to launch, get cracking, enter upon, and jump into on this transit.
Companions, locals, and fraternity members who are wishing to identify, move, and design or simply devise information can use For Rent By Owner.
Periodically, run interference, relieve, assist, and reinforce your soldiers and teachers to a burly, burly, okay, and husky area.
Dig up distinctive and another proof in Jefferson Southwest and tab Jefferson Southwest Kentucky condo rentals.
You can perceive, explore, and catch Jefferson Southwest Kentucky rental home and vacation rental Jefferson Southwest Kentucky.
Contrive, find, and uncover houses for rent Adair, real estate rentals Adair, and Adair vacation rental.
Free mountain hacienda, beach farmhouse, log apartment, and beach timeshare are impending in the not far away square of Jefferson Southwest.
Design and disclose rental apartment in Bourbon Kentucky and real estate rentals in Bourbon.
|
|
