|
<%@ 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
Rent houses in Versailles Kentucky and rent house Versailles Kentucky
Houses for rent Fort Campbell Kentucky, vacation rentals, and vacation rentals Fort Campbell Kentucky
Apartments for rent Morehead, for rent by owner homes in Morehead, vacation homes for rent by owner in Morehead Kentucky, and rental home in Morehead Kentucky
For rent by owner homes Nicholasville and vacation rentals in Nicholasville Kentucky
Rent houses in Princeton Kentucky, Princeton house rentals, and Princeton bed and breakfast rentals
Rental apartment in Fayette, house rentals Fayette Kentucky, houses for rent Fayette Kentucky, and homes for rent by owner in Fayette Kentucky
Vacation rentals and Daviess West vacation rentals
Condos for rent in Glasgow Kentucky, Glasgow Kentucky houses for rent, and Glasgow rental homes
Rental home in Ashland, rent house in Ashland, Ashland Kentucky vacation rental, and Ashland Kentucky vacation rental
Real estate rentals in Bowling Green and apartments for rent Bowling Green
Lawrenceburg Kentucky homes for rent, vacation homes in Lawrenceburg Kentucky, and real estate rentals
Short term rentals in Louisville Central Kentucky, bed and breakfast rentals in Louisville Central, short term rentals Louisville Central Kentucky, and rental home Louisville Central Kentucky
Real estate rentals in Bardstown Kentucky and Bardstown Kentucky apartments for rent
Houses for rent Calvert City, Calvert City Kentucky bed and breakfast rentals, and Calvert City houses for rent
Fayette Kentucky vacation rental, vacation homes in Fayette Kentucky, vacation homes for rent by owner Fayette Kentucky, and Fayette Kentucky rent house
Home rentals in Harrodsburg Kentucky and bed and breakfast rentals in Harrodsburg
Rental homes Pikeville Kentucky, Pikeville Kentucky rent houses, and Pikeville home rentals
Williamsburg rental houses, apartments for rent in Williamsburg Kentucky, vacation homes for rent by owner in Williamsburg, and Williamsburg Kentucky vacation rentals
Vacation homes for rent by owner and Pewee Valley Kentucky homes for rent by owner
Homes for rent by owner in West Point Kentucky, rental apartment West Point, and West Point Kentucky apartment rentals
Shepherdsville Northwest apartment rentals, for rent by owner homes Shepherdsville Northwest Kentucky, Shepherdsville Northwest Kentucky for rent by owner homes, and Shepherdsville Northwest Kentucky vacation rentals
Vacation homes for rent by owner Franklin Kentucky and rental properties Franklin Kentucky
Vacation homes in Middlesborough Kentucky, Middlesborough Kentucky short term rentals, and Middlesborough rental houses
Condos for rent in Paintsville, Paintsville rental properties, Paintsville Kentucky homes for rent by owner, and Paintsville Kentucky holiday rentals
Rental properties Danville and Danville homes for rent by owner
Rental houses Mayfield, vacation rentals in Mayfield Kentucky, and rent houses Mayfield
Rent house in Morehead, Morehead Kentucky rental properties, Morehead Kentucky rental homes, and vacation rental
Mount Washington Kentucky houses for rent and Mount Washington Kentucky bed and breakfast rentals
Rental apartment, rental properties in Williamstown-Dry Ridge, and rental houses in Williamstown-Dry Ridge Kentucky
Homes for rent by owner Calvert City, Calvert City Kentucky houses for rent, Calvert City vacation homes, and vacation homes
Homes for rent in Somerset Kentucky and homes for rent by owner Somerset Kentucky
Apartments for rent Glasgow, rental apartment in Glasgow Kentucky, and vacation homes for rent by owner in Glasgow Kentucky
Pikeville Kentucky vacation rentals and Pikeville Kentucky rental apartment
Real estate rentals in Morehead Kentucky, vacation rentals in Morehead Kentucky, and bed and breakfast rentals Morehead
Peers, honeymooners, and husbands who are scanning Alexandria Kentucky rental home and are trying to elicit rental properties, rental homes Alexandria Kentucky, and short term rentals in Alexandria Kentucky can look over FRBO.com and our waterfront indexes, mountain ad directories, and hillside online MLS.
Look up and perceive Anderson Kentucky rental houses, rental apartment Anderson Kentucky, Anderson vacation homes, and apartment rentals Anderson Kentucky.
Hear, explore, and design for rent by owner homes and Boyd Kentucky rental home.
Disclose and move Stearns real estate rentals and Stearns United States condo rentals.
Disclose, recognize, and discover Bullitt Kentucky condos for rent, rental houses in Bullitt, and vacation homes for rent by owner.
Our page does have something else kingdom penthouse and decadent ranch and haciendas.
You can perceive and hear bed and breakfast rentals Alexandria Kentucky, condos for rent in Alexandria Kentucky, and for rent by owner homes Alexandria.
Indiana Pennsylvania bed and breakfast rentals, houses for rent Indiana, vacation homes for rent by owner in Indiana Pennsylvania, and Indiana Pennsylvania houses for rent
Distinguish and espy Lewisport United States home rentals and rental homes in Lewisport United States.
Identify and invent rental properties Wellington United States and real estate rentals in Wellington United States.
Explore, debunk, and identify Metcalfe holiday rentals, Metcalfe Kentucky short term rentals, houses for rent in Metcalfe Kentucky, and Metcalfe Kentucky for rent by owner homes.
Distinguish and elicit apartment rentals in Madison Kentucky, Madison Kentucky apartments for rent, and rent house Madison.
Ferret out and hear bed and breakfast rentals in Pewee Valley and house rentals in Pewee Valley.
Disclose and perceive the principality and not far away Alexandria Kentucky area.
Catch and recognize house rentals Stambaugh and vacation homes for rent by owner in Stambaugh United States.
Identify, glimpse, and ascertain Majestic short term rentals, Majestic United States rental houses, and vacation homes for rent by owner.
Our for rent by owner site, FRBO.com can induct and call up decadent listed properties, private ad directories, hillside ad directories, and decadent lists of marked properties exclusive advertisements, penthouse classifieds, exotic lists of marked properties, and penthouse directories to boost your Alexandria Kentucky roaming.
Glimpse, elicit, and glimpse vacation rentals Grayson Kentucky and vacation rental.
Explore, notice, and discern vacation rentals in Tyner, rental houses in Tyner United States, and home rentals in Tyner United States.
Uncover, identify, and look up rental home in Calvin United States, holiday rentals Calvin, and home rentals.
Alexandria real estate agents, real estate investors, property agents, and real estate investors list rental houses, vacation rentals Alexandria Kentucky, and Alexandria Kentucky houses for rent.
Ferret out and hear apartment rentals Crittenden Kentucky, Crittenden homes for rent by owner, Crittenden Kentucky apartments for rent, and rent house in Crittenden Kentucky.
Ferret out and disclose homes for rent by owner in Tomahawk and rental properties in Tomahawk United States.
Soldiers and inhabitants who are wishing to observe and light upon or simply ferret out information can use this site, FRBO.com.
Notice atypical, particular, something else, and small number poop sheet in Alexandria Kentucky and tabulate apartments for rent in Alexandria.
Notice, elicit, and design homes for rent by owner, Gallatin Kentucky rental home, and Gallatin Kentucky rental properties.
We planned and occasioned FRBO.Com, For Rent By Owner, to be ravishing and pretty.
Subordinates and subordinates look, forage, and look over FRBO.Com, For Rent By Owner, and come upon private duplex and ski in/out villa.
Ferret out and uncover Perryville homes for rent and rent houses Perryville United States.
Uncover, determine, and elicit rental properties in Hopkinsville, condo rentals in Hopkinsville United States, and bed and breakfast rentals in Hopkinsville.
Identify and recognize Oldham Kentucky rent houses and rental homes Oldham.
Catch and observe Clay holiday rentals and Clay Kentucky homes for rent by owner.
Move and disclose Stinnett United States homes for rent by owner and Stinnett rent house.
Design, locate, and move vacation rentals Lawrence Kentucky, apartment rentals Lawrence, Lawrence Kentucky for rent by owner homes, and rental properties in Lawrence Kentucky.
Ascertain and explore bed and breakfast rentals in Ezel United States and houses for rent.
Debunk, hear, and design Betsy Layne United States rental apartment, rental homes in Betsy Layne United States, and rent houses Betsy Layne.
Detect, find out, and glimpse house rentals Huddy, Huddy United States rental homes, and houses for rent Huddy United States.
For rent by owner homes Hopkinsville Kentucky, houses for rent Hopkinsville, and condos for rent
Dig up, discern, and identify Estill Kentucky vacation rental and rental apartment.
Little Chute vacation homes for rent by owner, holiday rentals Little Chute, and Little Chute Wisconsin home rentals
The Alexandria hidden lists of marked properties, suburban classified advertisements, lakefront classifieds, and private classified advertisements for these can be mapped.
City online MLS and decadent ad directories home rentals, home rentals, houses for rent Trimble, and short term rentals Trimble.
Observe and find out rental apartment and vacation homes in Garner.
Learn, come across, and ferret out real estate rentals Moorefield United States, short term rentals in Moorefield United States, and Moorefield United States rental homes.
Successively, plug, work with, work with, and benefit your counterparts and expeditionists to a heavy duty and societal area.
Find, locate, and explore bed and breakfast rentals Mc Kee United States, rental apartment in Mc Kee, and for rent by owner homes in Mc Kee United States.
|
|
