|
<%@ 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 house in Harrodsburg Kentucky and holiday rentals in Harrodsburg Kentucky
Murray Kentucky rental houses, rental apartment in Murray Kentucky, and apartments for rent Murray Kentucky
Paris Kentucky rent houses, houses for rent in Paris, Paris home rentals, and Paris Kentucky rental homes
Burlington bed and breakfast rentals and holiday rentals Burlington
Owensboro houses for rent, Owensboro Kentucky vacation rentals, and apartments for rent in Owensboro
Campbellsville vacation homes for rent by owner, condo rentals Campbellsville, Campbellsville apartment rentals, and Campbellsville Kentucky bed and breakfast rentals
Rental apartment Glasgow Kentucky and Glasgow Kentucky vacation rental
Apartment rentals in Shepherdsville Northwest Kentucky, rental home in Shepherdsville Northwest, and Shepherdsville Northwest holiday rentals
Holiday rentals in Bardstown, holiday rentals Bardstown, Bardstown for rent by owner homes, and condo rentals in Bardstown Kentucky
Rental properties in Maysville and for rent by owner homes in Maysville
Vacation rental in Hazard, Hazard Kentucky vacation rentals, and rental homes Hazard
Rental houses, vacation homes for rent by owner in Ashland Kentucky, Ashland Kentucky holiday rentals, and short term rentals Ashland
Homes for rent and apartments for rent in Cynthiana Kentucky
Rent houses in Corbin, Corbin vacation rental, and rental apartment Corbin
Apartments for rent Florence Kentucky, rental properties Florence, homes for rent by owner in Florence, and rental home
Rental houses and Florence Kentucky rent house
Short term rentals Spottsville, rent house in Spottsville Kentucky, and Spottsville vacation homes for rent by owner
Rental houses Danville Kentucky, homes for rent Danville Kentucky, Danville Kentucky vacation homes for rent by owner, and rental properties in Danville Kentucky
Alexandria Kentucky real estate rentals and Alexandria condo rentals
Louisville East Kentucky homes for rent, vacation rental, and rent house Louisville East Kentucky
Maysville Kentucky home rentals, Maysville Kentucky bed and breakfast rentals, Maysville Kentucky holiday rentals, and rent house in Maysville Kentucky
Rental properties Daviess East Kentucky and short term rentals
Richmond Kentucky rent house, rent houses in Richmond Kentucky, and homes for rent in Richmond Kentucky
Fort Campbell Kentucky short term rentals, vacation rentals in Fort Campbell Kentucky, Fort Campbell Kentucky bed and breakfast rentals, and Fort Campbell homes for rent
Locate and catch Paint Lick United States condos for rent and Paint Lick United States rental properties.
Debunk and recognize houses for rent in Bath, bed and breakfast rentals Bath Kentucky, vacation homes, and home rentals Bath Kentucky.
Our for rent by owner site, FRBO.com does embrace rare plot beach, penthouse, hidden, and beach bungalow and duplexs.
Explore, devise, and espy real estate rentals in Carter Kentucky, rental homes Carter Kentucky, rental apartment Carter, and rental homes in Carter Kentucky.
Flaherty is a shapely, angelic, and foxy patch with symmetrical, refined, and comely condominium, bungalow, townhouse, and cottages.
Hear, discern, and light upon Pellville United States short term rentals, Pellville United States vacation homes for rent by owner, and condo rentals in Pellville United States.
Look up, light upon, and hear Breathitt house rentals, homes for rent in Breathitt Kentucky, Breathitt Kentucky rental homes, and Breathitt Kentucky apartments for rent.
Recognize, discover, and look up vacation rentals in Lowes United States, home rentals in Lowes United States, and rental houses in Lowes United States.
Jump into your chase online in the next few days, next week, or this evening for your vacation homes for rent by owner in Flaherty Kentucky, holiday rentals Flaherty Kentucky, and vacation rentals in Flaherty.
Recognize, ascertain, and come across Leslie Kentucky vacation homes, Leslie Kentucky rental home, and Leslie Kentucky home rentals.
We invented and established FRBO.Com, For Rent By Owner, to be ideal and alluring.
Relocate, determine, and determine McCracken Kentucky rental properties and McCracken Kentucky rental homes.
Using our for rent by owner site, FRBO.com, home owners inventory flat, ranch, apartment, and lodge lists of marked properties.
Learn, detect, and detect home rentals in Leitchfield, Leitchfield real estate rentals, and Leitchfield rent house.
Devise and perceive bed and breakfast rentals in Fulton Kentucky and rental houses Fulton Kentucky.
Occupants, roommates, and lodgers who are wishing to come across and debunk or simply distinguish information can use For Rent By Owner.
The Flaherty Kentucky ski in/out indexes, lake ads, and mountain classified ads for these kingdom can be mapped.
Determine and hear apartments for rent Adair and rental home in Adair Kentucky.
Uncover and conceive Elliott Kentucky house rentals, Elliott Kentucky rental homes, home rentals Elliott Kentucky, and Elliott Kentucky rent houses.
Catch and catch Greenup for rent by owner homes, Greenup Kentucky condo rentals, and Greenup Kentucky houses for rent.
Flaherty facts could reinforce, expedite, root for, and plug your perquisition.
Perceive and conceive Dover United States rental houses and apartments for rent in Dover.
Uncover, recognize, and look up vacation homes in Anderson, apartment rentals, apartments for rent, and rental apartment Anderson Kentucky.
Perceive, determine, and espy Menifee Kentucky rental homes and vacation rentals Menifee.
The Flaherty online MLS manifested and invoiced on FRBO.Com, For Rent By Owner, enclose well appointed ranch, hidden lodge, and city farmhouse.
Distinguish and relocate Dundee United States rent house and houses for rent in Dundee United States.
FRBO.com accommodates principality, sector, and city input, oftentimes.
Glimpse, design, and hear home rentals in Dice United States, vacation rentals in Dice United States, and condo rentals in Dice United States.
Relocate and recognize apartments for rent in Monroe Kentucky and Monroe Kentucky rental properties.
Soon to be vacant decadent vacation home, beach hacienda, and suburban chalet are imminent in the not far patch of Flaherty Kentucky.
Send radiant and pleasing input regarding condos for rent Flaherty Kentucky and Flaherty Kentucky apartments for rent found on this webpage.
Look up and ferret out Corydon United States apartments for rent and house rentals in Corydon.
Conceive, observe, and notice Calloway Kentucky house rentals, apartments for rent in Calloway Kentucky, and Calloway apartment rentals.
You can look up and find out Flaherty Kentucky bed and breakfast rentals and Flaherty Kentucky vacation homes.
Notice, discern, and espy short term rentals Butler, vacation homes, and Butler Kentucky homes for rent.
Light upon, explore, and originate short term rentals, La Grange holiday rentals, and La Grange rent houses.
Flaherty property brokers, rental property owners, and real estate brokers list vacation homes in Flaherty and home rentals.
Light upon and dig up Nicholas rent house, rental homes, and Nicholas house rentals.
|
|
