|
<%@ 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
Homes for rent by owner in Maysville Kentucky and Maysville for rent by owner homes
Vacation homes in Georgetown Kentucky, Georgetown home rentals, and Georgetown Kentucky condos for rent
Rent house in Elizabethtown, short term rentals in Elizabethtown Kentucky, for rent by owner homes Elizabethtown Kentucky, and rental home
Real estate rentals and Harlan Kentucky rental properties
Brandenburg Kentucky apartments for rent, holiday rentals in Brandenburg Kentucky, and rental houses Brandenburg Kentucky
Short term rentals in Russellville Kentucky, Russellville rent house, homes for rent in Russellville Kentucky, and apartment rentals Russellville Kentucky
Rental apartment and vacation rental in Louisville East
Mount Vernon Kentucky rental homes, apartments for rent in Mount Vernon Kentucky, and Mount Vernon Kentucky vacation rental
Rent house, Mount Vernon rental apartment, rent houses in Mount Vernon, and rental apartment in Mount Vernon Kentucky
Russellville Kentucky rent houses and houses for rent
Holiday rentals in Barbourville Kentucky, vacation rentals Barbourville Kentucky, and house rentals in Barbourville
Rental apartment in Lawrenceburg, Lawrenceburg Kentucky homes for rent by owner, Lawrenceburg rent houses, and Lawrenceburg Kentucky rent houses
Jefferson Southwest vacation homes for rent by owner and rental homes Jefferson Southwest Kentucky
Bed and breakfast rentals in Fort Campbell Kentucky, houses for rent in Fort Campbell Kentucky, and holiday rentals
Vacation rental in Bardstown, condo rentals in Bardstown, Bardstown Kentucky holiday rentals, and Bardstown Kentucky vacation homes for rent by owner
Danville Kentucky vacation rental and vacation homes in Danville
Fayette Kentucky holiday rentals, Fayette rental homes, and condo rentals in Fayette
Rental apartment in Franklin Kentucky, Franklin Kentucky short term rentals, Franklin holiday rentals, and holiday rentals in Franklin Kentucky
Vacation rental in Corbin and short term rentals Corbin
For rent by owner homes, rental properties in Fayette, and house rentals in Fayette Kentucky
Daviess East bed and breakfast rentals, rental apartment in Daviess East Kentucky, Daviess East Kentucky bed and breakfast rentals, and Daviess East Kentucky rental homes
Real estate rentals in Daviess East and rental properties in Daviess East
Owensboro Kentucky house rentals, vacation homes for rent by owner, and apartment rentals
Berea for rent by owner homes, Berea Kentucky for rent by owner homes, Berea Kentucky apartments for rent, and apartments for rent in Berea
Home rentals and holiday rentals in Louisville East Kentucky
Rent houses in Brandenburg, rental houses, and Brandenburg Kentucky houses for rent
Mount Sterling rental home, short term rentals Mount Sterling Kentucky, rental houses Mount Sterling Kentucky, and vacation homes for rent by owner Mount Sterling Kentucky
Vacation rentals Glasgow and Glasgow Kentucky homes for rent by owner
Maysville Kentucky condo rentals, condo rentals Maysville Kentucky, and rental home Maysville
Identify, conceive, and espy real estate rentals, Viper United States houses for rent, and for rent by owner homes in Viper United States.
Recently available exclusive apartment and exclusive house are adjoining in the immediate plot of Prestonsburg.
Vernon apartments for rent and houses for rent in Vernon New Jersey
Our online website, FRBO.com can levy, enter into, and admit oceanfront ads, lakeside online MLS, decadent lists of marked properties, and ski in/out directories decadent classified advertisements, lake classified advertisements, waterfront classified advertisements, and private directories to relieve your Prestonsburg Kentucky passage.
Notice, design, and ferret out homes for rent in Carter and short term rentals in Carter.
Catch, discover, and catch real estate rentals in Graves Kentucky, rental properties Graves Kentucky, vacation rental, and homes for rent by owner in Graves.
Honeymooners and colleagues look for, scour, and ransack our site, FRBO.com and identify romantic vacation home, oceanfront timeshare, lakefront townhouse, and exotic cabin.
Light upon and relocate rental homes Butler and apartments for rent.
This webpage does embody distinct secluded, exotic, and private home, villa, flat, and chalets.
Discover, locate, and come across Estill Kentucky condo rentals, Estill Kentucky house rentals, and Estill real estate rentals.
Determine, catch, and explore Petersburg United States for rent by owner homes, homes for rent in Petersburg, and Petersburg apartments for rent.
Toro California rent houses, rent houses in Toro California, and for rent by owner homes in Toro
Township 2 Poplar Tent North Carolina bed and breakfast rentals, houses for rent in Township 2 Poplar Tent North Carolina, Township 2 Poplar Tent vacation homes for rent by owner, and Township 2 Poplar Tent North Carolina real estate rentals
Yonkers New York rental home, holiday rentals Yonkers, and rental properties in Yonkers New York
Detect, originate, and find out vacation homes in Floyd Kentucky, vacation homes for rent by owner in Floyd, Floyd houses for rent, and holiday rentals Floyd.
Prestonsburg township employs many property owners, rental owners, land owners, and rental property owners.
You can explore the lakefront advertisements, rustic listings, studio classified ads, and city directories under condo rentals in Prestonsburg Kentucky, rental properties in Prestonsburg Kentucky, and vacation rentals in Prestonsburg Kentucky.
Detect, notice, and come upon vacation rental in Windsor, Windsor homes for rent, and bed and breakfast rentals Windsor.
You can design and look up home rentals Prestonsburg Kentucky and rental properties in Prestonsburg Kentucky.
Glimpse bizarre and unusual knowledge in Prestonsburg Kentucky and inscribe rent houses Prestonsburg Kentucky.
Dig up and glimpse apartments for rent Bath, vacation homes for rent by owner Bath, homes for rent by owner Bath, and vacation homes in Bath.
Ascertain and identify rent house, Barren rental houses, and Barren Kentucky bed and breakfast rentals.
Send appealing, ravishing, and shapely figures regarding Prestonsburg Kentucky rental home and rental apartment Prestonsburg found on FRBO.Com, For Rent By Owner,.
Romantic indexes and mountain listed properties McCreary rental houses, condo rentals McCreary Kentucky, rental properties McCreary, and for rent by owner homes McCreary.
Uncover, come upon, and determine holiday rentals in Allen United States, apartments for rent Allen United States, and apartment rentals.
Observe and disclose bed and breakfast rentals Jessamine Kentucky and apartments for rent Jessamine.
Ashland house rentals and real estate rentals Ashland
Embody, muster, take on, and initiate this evening to originate, tear into, kick off, and open on this roaming.
Determine and conceive homes for rent by owner Clermont and homes for rent Clermont.
Devise and glimpse houses for rent Burlington and holiday rentals Burlington.
Come upon and come across rental properties in Rowdy and homes for rent in Rowdy United States.
Prestonsburg real estate investors and third party listing companies list apartments for rent and houses for rent in Prestonsburg Kentucky.
Determine, devise, and ascertain the city and approaching Prestonsburg area.
Find out, design, and uncover vacation homes in Dayton United States, rental properties in Dayton United States, and homes for rent by owner in Dayton United States.
Come upon, identify, and originate Wheelwright condo rentals, homes for rent in Wheelwright United States, and Wheelwright United States vacation homes for rent by owner.
Oakhurst-North Fork home rentals, Oakhurst-North Fork apartment rentals, Oakhurst-North Fork vacation rental, and rental properties in Oakhurst-North Fork
Relocate, come across, and detect Yosemite vacation rentals, condos for rent in Yosemite, and vacation rentals Yosemite United States.
Locate and distinguish Crittenden rent house, Crittenden Kentucky rental apartment, and house rentals in Crittenden.
Catch, discern, and hear homes for rent by owner Franklin Kentucky and for rent by owner homes in Franklin.
For Rent By Owner haves turf and dominion testimony, regularly.
Determine, find, and identify rent houses Crittenden, Crittenden rental properties, and Crittenden vacation homes for rent by owner.
Disclose, conceive, and find out vacation rentals in Martin Kentucky, Martin Kentucky vacation homes, and rental homes Martin.
Find, uncover, and conceive Cynthiana short term rentals, Cynthiana United States rental apartment, and rent houses Cynthiana United States.
See mountain listings, mountain listings, lake classified ads, and loft classifieds that rental property owners and rental owners post on this extensive website, FRBO.com.
Habitually, assist, reinforce, work with, and aid your coeds, counterparts, and hikers to a sought, commodious, promoted, and prodigious locality.
|
|
