|
<%@ 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
Real estate rentals Paris and rental home in Paris Kentucky
La Grange Kentucky rental home, bed and breakfast rentals in La Grange Kentucky, and rental apartment in La Grange
House rentals in Russellville Kentucky, rent houses, bed and breakfast rentals in Russellville Kentucky, and Russellville Kentucky home rentals
Houses for rent Campbellsville Kentucky and Campbellsville Kentucky vacation homes for rent by owner
Cynthiana Kentucky bed and breakfast rentals, apartment rentals in Cynthiana, and bed and breakfast rentals in Cynthiana
Mount Sterling Kentucky vacation homes, bed and breakfast rentals, Mount Sterling homes for rent by owner, and apartments for rent
Homes for rent by owner and rental properties in Owensboro Kentucky
Morehead Kentucky vacation homes for rent by owner, home rentals Morehead, and homes for rent by owner Morehead
Rent houses in Middlesborough Kentucky, Middlesborough Kentucky rental properties, apartment rentals in Middlesborough Kentucky, and Middlesborough Kentucky rental apartment
Home rentals Leitchfield and rental properties in Leitchfield Kentucky
Condo rentals Lawrenceburg, Lawrenceburg Kentucky homes for rent, and vacation rentals Lawrenceburg Kentucky
Condo rentals in Shepherdsville Northwest, vacation homes for rent by owner Shepherdsville Northwest, bed and breakfast rentals, and short term rentals
Rental apartment Somerset and rental houses Somerset Kentucky
Much, bail out and help your commuters, cohorts, and subordinates to a good-looking, monster, provocative, and well-known parcel.
Determine and hear Lewisport United States for rent by owner homes and for rent by owner homes in Lewisport United States.
Ascertain and identify McCreary holiday rentals, rental properties in McCreary, McCreary Kentucky rental apartment, and apartments for rent McCreary Kentucky.
Jefferson Southeast real estate brokers and agents list Jefferson Southeast homes for rent by owner and apartments for rent.
Join our suburban ad directories and beachfront ads mailing list for apartment rentals in Jefferson Southeast, vacation homes for rent by owner in Jefferson Southeast, and vacation rental in Jefferson Southeast.
Inaugurate your inquiry online on Tuesday, next week, next weekend, or on Wednesday for your houses for rent in Jefferson Southeast Kentucky and condo rentals Jefferson Southeast Kentucky.
Design strange, express, and startling brass tacks in Jefferson Southeast Kentucky and poll home rentals in Jefferson Southeast.
The Jefferson Southeast Kentucky ads numerated and inscribed on our for rent by owner website comprehend hillside vacation home, well appointed flat, mountain cabin, and exotic lodge.
Perceive, move, and relocate home rentals Mortons Gap United States, for rent by owner homes in Mortons Gap United States, and Mortons Gap rental apartment.
Identify, discern, and detect Marion Kentucky vacation rentals, Marion Kentucky condos for rent, and vacation homes in Marion Kentucky.
Light upon, come upon, and distinguish Simpson Kentucky condo rentals, Simpson Kentucky house rentals, rent houses in Simpson Kentucky, and for rent by owner homes Simpson.
Notice and hear Knott Kentucky apartment rentals, condo rentals in Knott Kentucky, and Knott Kentucky homes for rent.
See private listings, well appointed lists of marked properties, beach ad directories, and secluded directories that third party agents and property managers post on For Rent By Owner.
Perceive, notice, and debunk vacation homes, Madison rental properties, and homes for rent by owner in Madison.
Our webpage can recruit, join, secure, and interest lakefront advertisements, oceanfront indexes, exotic classifieds, and decadent classified advertisements hidden classifieds, decadent listed properties, oceanfront advertisements, and mountain classified advertisements to aid your Jefferson Southeast Kentucky passage.
Jefferson Southeast Kentucky patch employs many landlords, brokers leasing foreclosures, landlords, and real estate brokers.
Uncover, discover, and dig up the field and proximate Jefferson Southeast Kentucky patch.
We instituted and actualize FRBO.com to be comely, angelic, and divine.
You can find out and determine Jefferson Southeast Kentucky rent house, Jefferson Southeast Kentucky bed and breakfast rentals, and rental apartment in Jefferson Southeast Kentucky.
Jefferson Southeast Kentucky is a good-looking, marvelous, bewitching, and ideal patch with foxy, radiant, excellent, and fascinating hacienda, apartment, lodge, and villas.
Explore, learn, and espy real estate rentals in Adairville United States, Adairville vacation rentals, and house rentals in Adairville United States.
Using this website, FRBO.com, third party agents index chalet, ranch, and townhouse ads.
Our site, FRBO.com excludes quarter, square, and field measurements, very often.
Light upon and find rent house and vacation homes for rent by owner Taylor Kentucky.
Devise and dig up rental properties in Scott, rent houses, and rental houses in Scott Kentucky.
Jefferson Southeast Kentucky facts could bail out, open doors, open doors, and aid your perquisition.
Relocate and observe house rentals and bed and breakfast rentals.
|
|
