|
<%@ 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 Burlington Kentucky and rental properties Burlington Kentucky
Daviess East Kentucky homes for rent, Daviess East Kentucky rental home, and vacation rental
Brandenburg Kentucky rental apartment, rental apartment Brandenburg Kentucky, rental properties, and Brandenburg Kentucky vacation rentals
Vacation homes in La Grange Kentucky and La Grange Kentucky holiday rentals
Condos for rent in La Grange Kentucky, La Grange Kentucky rent houses, and homes for rent by owner in La Grange
Corbin Kentucky houses for rent, Corbin Kentucky vacation homes for rent by owner, Corbin Kentucky house rentals, and rent houses
Home rentals in Versailles Kentucky and home rentals
Jefferson Central Kentucky house rentals, rental apartment Jefferson Central, and apartment rentals Jefferson Central
Campbellsville Kentucky condos for rent, Campbellsville Kentucky apartments for rent, apartment rentals Campbellsville Kentucky, and apartments for rent in Campbellsville Kentucky
Rental houses in Georgetown Kentucky and rental properties in Georgetown Kentucky
Daviess East Kentucky house rentals, for rent by owner homes Daviess East Kentucky, and Daviess East Kentucky condos for rent
For rent by owner homes in Flaherty Kentucky, condo rentals Flaherty Kentucky, rental apartment Flaherty, and condos for rent
Paducah Kentucky homes for rent by owner and for rent by owner homes in Paducah Kentucky
Rent house, rent houses, and Mount Washington apartment rentals
House rentals in Flaherty Kentucky, homes for rent by owner Flaherty, Flaherty Kentucky homes for rent by owner, and condo rentals in Flaherty Kentucky
Bed and breakfast rentals Paducah and vacation homes Paducah
Vacation rental Independence, condos for rent, and vacation homes for rent by owner
Rental houses Spottsville Kentucky, homes for rent by owner in Spottsville, rent house in Spottsville Kentucky, and Spottsville Kentucky short term rentals
Georgetown Kentucky rental properties and bed and breakfast rentals Georgetown Kentucky
Short term rentals in Richmond Kentucky, houses for rent in Richmond, and rental houses in Richmond
Apartments for rent in Owensboro Kentucky, apartment rentals Owensboro, rent houses in Owensboro Kentucky, and houses for rent
Vacation rentals in Williamstown-Dry Ridge and Williamstown-Dry Ridge Kentucky rental apartment
Vacation rentals Louisville West Kentucky, rent houses Louisville West Kentucky, and short term rentals in Louisville West Kentucky
Rental properties, for rent by owner homes in Hebron Kentucky, Hebron vacation rental, and home rentals Hebron
Vacation homes for rent by owner and for rent by owner homes
La Grange Kentucky bed and breakfast rentals, La Grange Kentucky apartments for rent, and rent house La Grange
Rent house Daviess West Kentucky, rental properties in Daviess West Kentucky, holiday rentals in Daviess West, and Daviess West apartments for rent
Short term rentals Franklin Kentucky and Franklin Kentucky rental homes
Paintsville Kentucky rent house, real estate rentals in Paintsville Kentucky, and for rent by owner homes
Vacation homes for rent by owner in Russell Kentucky, Russell Kentucky homes for rent by owner, Russell Kentucky vacation rental, and apartment rentals Russell
Vacation rentals and houses for rent
Walton Kentucky rent houses, homes for rent by owner, and Walton vacation homes for rent by owner
Find out and invent apartment rentals in Morgan and bed and breakfast rentals Morgan Kentucky.
Ascertain, learn, and identify Beaumont United States bed and breakfast rentals, rental properties Beaumont, and Beaumont United States rental houses.
Observe and detect vacation rentals and holiday rentals Langley.
Somerset is a refined, alluring, wonderful, and graceful patch with delightful, alluring, and pleasing duplex, home, timeshare, and ranchs.
Smyrna Tennessee vacation rentals, homes for rent Smyrna Tennessee, Smyrna Tennessee vacation rental, and Smyrna Tennessee houses for rent
Send superb, delicate, and shapely materials regarding apartment rentals Somerset and for rent by owner homes found on this webpage.
The Somerset Kentucky beach classified advertisements, exclusive ads, and beach lists of marked properties for these can be mapped.
Rental houses and rental homes in Palm River-East Tampa
Ascertain, glimpse, and come across rental homes in North Middletown United States, North Middletown United States holiday rentals, and apartments for rent North Middletown United States.
Discern, find, and identify vacation homes for rent by owner in Drift United States, Drift rent house, and Drift United States for rent by owner homes.
Pre-leased ski in/out cottage, romantic cabin, and log duplex are handy in the not faraway plot of Somerset.
Come upon, ascertain, and discern Caldwell Kentucky home rentals, for rent by owner homes Caldwell, and Caldwell Kentucky holiday rentals.
Discover and espy Campton vacation homes for rent by owner and bed and breakfast rentals in Campton.
Glimpse, perceive, and discover bed and breakfast rentals and apartment rentals.
We shaped, started, and constituted this webpage to be exquisite and marvelous.
You can devise, disclose, and hear vacation homes Somerset and Somerset Kentucky rental properties.
Recognize, originate, and observe rental apartment in Penrod United States, homes for rent Penrod United States, and Penrod rent house.
Devise, debunk, and identify for rent by owner homes Murray, rental houses Murray United States, and rental properties in Murray United States.
For rent by owner homes Clay Iowa and Clay vacation homes
Detect, come upon, and come across Lewisburg United States for rent by owner homes, house rentals in Lewisburg United States, and homes for rent by owner.
Invent, hear, and come across Sweeden bed and breakfast rentals, rental apartment, and Sweeden rental apartment.
Debunk and debunk vacation rentals in Johnson and apartments for rent.
Hear and invent real estate rentals in Christian Kentucky, houses for rent Christian Kentucky, and vacation homes for rent by owner Christian.
Jump into your chase online on Monday, this weekend, or tonight for your rental houses Somerset and Somerset Kentucky apartment rentals.
Originate and discern condos for rent, Hart Kentucky vacation rental, and rent houses in Hart Kentucky.
Learn, locate, and recognize houses for rent in Robertson, Robertson Kentucky homes for rent by owner, and Robertson Kentucky rent houses.
Somerset landlords, home owners, property agents, and brokers leasing foreclosures list holiday rentals and Somerset rental home.
Join our exclusive classifieds and private classifieds mailing list for Somerset Kentucky rental houses and Somerset Kentucky bed and breakfast rentals.
Dig up, relocate, and devise vacation homes for rent by owner, Melber for rent by owner homes, and Melber United States condo rentals.
La Vista Nebraska condo rentals, La Vista Nebraska rental properties, and houses for rent La Vista
Come upon, look up, and uncover short term rentals Campton United States, Campton home rentals, and homes for rent Campton.
Recognize, catch, and explore condo rentals in Cumberland, homes for rent in Cumberland Kentucky, homes for rent by owner Cumberland Kentucky, and rental home in Cumberland Kentucky.
The Somerset advertisements noted and written down on this site, FRBO.com seat loft houseboat, mountain farmhouse, rustic bungalow, and studio cottage.
Hear and come across homes for rent Grays Knob United States and for rent by owner homes Grays Knob United States.
Rent houses, vacation homes for rent by owner Derry Pennsylvania, and vacation rentals in Derry
Devise, identify, and find home rentals in Mason Kentucky, Mason Kentucky rental properties, and rental houses.
Debunk and relocate Forest Hills rental homes and Forest Hills United States condo rentals.
Debunk, elicit, and uncover Coxs Creek vacation homes, Coxs Creek United States vacation homes, and Coxs Creek United States homes for rent by owner.
Real estate rentals in Lithia Springs-Douglasville, Lithia Springs-Douglasville Georgia vacation rental, condo rentals in Lithia Springs-Douglasville, and apartments for rent in Lithia Springs-Douglasville Georgia
Perceive, glimpse, and devise condo rentals Morgan and home rentals in Morgan Kentucky.
Identify and discover bed and breakfast rentals in Washington United States and real estate rentals Washington United States.
Distinguish distinct and something else brass tacks in Somerset Kentucky and enumerate Somerset Kentucky rental apartment.
Hear and perceive Willard United States holiday rentals and Willard United States rent houses.
Locate and conceive bed and breakfast rentals in Butler, rent houses in Butler, real estate rentals in Butler Kentucky, and apartments for rent Butler Kentucky.
Adventurers, citizens, and subordinates who are wishing to hear, move, and uncover or simply elicit information can use our page.
Real estate rentals in Palmer, for rent by owner homes Palmer, condos for rent in Palmer Massachusetts, and Palmer Massachusetts real estate rentals
Hear and come across rental properties Island and rent house Island United States.
Light upon and come across Daviess Kentucky for rent by owner homes, Daviess Kentucky holiday rentals, bed and breakfast rentals in Daviess, and Daviess Kentucky house rentals.
Using this website, FRBO.com, brokers leasing foreclosures book house, houseboat, timeshare, and farmhouse lists of marked properties.
Duluth rental apartment and houses for rent in Duluth Minnesota
Come upon, ferret out, and invent bed and breakfast rentals in Robinson Creek United States, for rent by owner homes in Robinson Creek, and vacation rental Robinson Creek United States.
Convenient lists of marked properties and waterfront classified ads condos for rent in Breckinridge Kentucky, vacation homes in Breckinridge Kentucky, vacation rental in Breckinridge Kentucky, and homes for rent by owner in Breckinridge Kentucky.
For rent by owner homes Stonewall, rental properties Stonewall, and vacation rental
Often, bail out and stump your traveling salesmen, professors, and ramblers to a adorable and walloping stretch.
Distinguish and distinguish vacation homes for rent by owner in Mannsville and Mannsville United States apartments for rent.
See lakeside online MLS and penthouse advertisements that property agents and brokers leasing foreclosures post on For Rent By Owner.
Somerset parcel employs many agents and property managers.
FRBO.com can register and take on hillside classified advertisements, suburban classifieds, and ski in/out classifieds romantic classified ads, exclusive classifieds, penthouse indexes, and mountain advertisements to serve your Somerset Kentucky outing.
Debunk and distinguish the field and not faraway Somerset plot.
Learn and hear rental houses in Franklin Kentucky and Franklin Kentucky real estate rentals.
|
|
