|
<%@ 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
Vacation homes for rent by owner in Independence Kentucky and condo rentals Independence Kentucky
Homes for rent by owner Shelbyville Kentucky, vacation rental, and houses for rent Shelbyville Kentucky
Leitchfield Kentucky vacation rental, holiday rentals in Leitchfield, Leitchfield Kentucky rental properties, and Leitchfield Kentucky vacation homes
Rent houses and Paris Kentucky home rentals
Homes for rent in Mount Sterling Kentucky, Mount Sterling Kentucky vacation homes for rent by owner, and Mount Sterling rental homes
Vacation rentals in Walton, apartments for rent in Walton Kentucky, real estate rentals in Walton, and Walton Kentucky condos for rent
Apartment rentals and London holiday rentals
Vacation homes for rent by owner in Bardstown Kentucky, vacation rentals Bardstown, and Bardstown Kentucky apartments for rent
Florence rental homes, Florence Kentucky vacation homes, Florence Kentucky real estate rentals, and rental properties in Florence Kentucky
Paris Kentucky condo rentals and real estate rentals Paris
Owensboro Kentucky house rentals, apartments for rent, and rental home in Owensboro
Vacation rental in Hebron Kentucky, Hebron Kentucky vacation rentals, short term rentals in Hebron Kentucky, and Hebron Kentucky condos for rent
Rental apartment and Maysville Kentucky real estate rentals
Vacation rentals in Covington Kentucky, apartment rentals in Covington Kentucky, and vacation rentals in Covington Kentucky
Jefferson Southeast Kentucky holiday rentals, holiday rentals in Jefferson Southeast, vacation homes for rent by owner, and rental houses in Jefferson Southeast Kentucky
Homes for rent by owner West Point Kentucky and West Point Kentucky for rent by owner homes
Walton Kentucky rental homes, Walton Kentucky rental homes, and condo rentals
Holiday rentals in Hopkinsville, apartment rentals in Hopkinsville, Hopkinsville for rent by owner homes, and rental properties Hopkinsville
Vacation homes for rent by owner in Russell Kentucky and rental houses Russell Kentucky
Apartment rentals, holiday rentals Calvert City Kentucky, and rental apartment in Calvert City Kentucky
Williamstown-Dry Ridge Kentucky vacation rental, Williamstown-Dry Ridge Kentucky rent house, vacation rentals in Williamstown-Dry Ridge, and bed and breakfast rentals in Williamstown-Dry Ridge Kentucky
Discern, find, and disclose Stopover house rentals, Stopover United States rental homes, and condo rentals in Stopover United States.
Glimpse and come across rent houses Russell and Russell Kentucky apartments for rent.
Observe, identify, and recognize condo rentals in Hardin, holiday rentals Hardin Kentucky, bed and breakfast rentals, and real estate rentals in Hardin Kentucky.
Disclose and come across Warren Kentucky homes for rent, Warren Kentucky house rentals, and apartments for rent Warren Kentucky.
Discover and contrive homes for rent in Magoffin Kentucky and Magoffin apartment rentals.
Locate, identify, and glimpse vacation homes Bath Kentucky, Bath Kentucky apartments for rent, and apartment rentals Bath Kentucky.
Find and debunk Haldeman for rent by owner homes and real estate rentals in Haldeman.
Our website, FRBO.com comprehends kingdom, stretch, state, and county goods, sometimes.
Move, originate, and explore houses for rent in Nicholas and Nicholas Kentucky holiday rentals.
Using our page, rental agents tab chalet and vacation home ad directories.
Espy, find, and espy real estate rentals Hart, condo rentals in Hart Kentucky, house rentals Hart Kentucky, and Hart rental home.
Espy and catch rent house in Coxs Creek and condos for rent in Coxs Creek.
Uncover, determine, and design homes for rent Scalf United States, rental properties in Scalf United States, and Scalf United States condos for rent.
Determine, glimpse, and distinguish Simpson Kentucky house rentals and home rentals Simpson Kentucky.
Discover, identify, and find out home rentals in Cecilia United States, Cecilia United States rental homes, and Cecilia holiday rentals.
Ascertain, explore, and identify houses for rent in Hi Hat United States, Hi Hat United States holiday rentals, and rent house in Hi Hat United States.
You can study the hidden ad directories, hillside classifieds, spacious ads, and lakefront classified ads under bed and breakfast rentals in Louisville West Kentucky, Louisville West condos for rent, and house rentals Louisville West Kentucky.
Recognize and detect vacation rental Dunnville and rent houses in Dunnville.
Light upon, observe, and recognize homes for rent by owner in Summersville United States, rental home, and vacation homes in Summersville United States.
Louisville West Kentucky testimony could back and push your hunt.
Conceive, ferret out, and ferret out houses for rent in Bullitt Kentucky, vacation homes for rent by owner, and house rentals.
Conceive, learn, and observe homes for rent in Junction City, rental apartment in Junction City United States, and Junction City United States bed and breakfast rentals.
Identify, detect, and come upon Adolphus homes for rent, apartment rentals Adolphus United States, and Adolphus apartments for rent.
Find and dig up apartment rentals in Nevisdale United States and homes for rent by owner Nevisdale.
Convenient listed properties and beachfront ads apartments for rent, for rent by owner homes Henderson, Henderson Kentucky for rent by owner homes, and rental apartment Henderson.
Notice and disclose Edmonson Kentucky vacation rental, Edmonson rental home, Edmonson Kentucky home rentals, and Edmonson Kentucky for rent by owner homes.
Recognize, perceive, and identify homes for rent in Nicholas, Nicholas short term rentals, apartments for rent Nicholas, and homes for rent Nicholas.
|
|
