|
<%@ 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
Short term rentals and rental home in Morehead Kentucky
Short term rentals in Fayette, bed and breakfast rentals in Fayette Kentucky, and home rentals
Rental homes in Murray Kentucky, Murray Kentucky vacation homes, rent houses in Murray Kentucky, and Murray vacation homes for rent by owner
Fort Campbell Kentucky rent houses and Fort Campbell rent houses
Richmond Kentucky home rentals, condo rentals Richmond Kentucky, and homes for rent in Richmond Kentucky
Rental apartment, holiday rentals in Mount Sterling, apartments for rent in Mount Sterling Kentucky, and Mount Sterling Kentucky houses for rent
For rent by owner homes in Jefferson Southwest Kentucky and Jefferson Southwest Kentucky rental homes
Rent houses in Leitchfield, holiday rentals in Leitchfield Kentucky, and Leitchfield Kentucky houses for rent
Home rentals, Louisville West real estate rentals, rental homes, and real estate rentals Louisville West
Condo rentals in Bardstown Kentucky and Bardstown Kentucky real estate rentals
Cynthiana Kentucky rental houses, houses for rent in Cynthiana, and Cynthiana Kentucky rent house
Bowling Green Kentucky homes for rent by owner, Bowling Green rent house, Bowling Green vacation rentals, and real estate rentals Bowling Green
Radcliff home rentals and Radcliff Kentucky vacation rental
Rent houses Bardstown Kentucky, holiday rentals in Bardstown Kentucky, and for rent by owner homes Bardstown
Vacation homes in Versailles, Versailles Kentucky real estate rentals, Versailles Kentucky holiday rentals, and real estate rentals in Versailles
Apartment rentals in Jefferson Northeast and Jefferson Northeast homes for rent
Homes for rent by owner in Jefferson Southwest Kentucky, rental apartment Jefferson Southwest Kentucky, and Jefferson Southwest Kentucky apartment rentals
Bed and breakfast rentals in Danville Kentucky, bed and breakfast rentals in Danville Kentucky, bed and breakfast rentals in Danville Kentucky, and Danville vacation rentals
Vacation rental in Corbin Kentucky and rental home in Corbin Kentucky
Rental houses in Mount Sterling, vacation rental, and homes for rent by owner in Mount Sterling
The Spottsville listed properties inscribed and posted on this site, For Rent By Owner (FRBO.com) eliminate beach lodge and hillside cabin.
Distinguish, relocate, and notice Ermine United States rent houses, vacation rentals Ermine, and rental home Ermine United States.
You can originate, design, and invent vacation homes for rent by owner in Spottsville and rental properties.
Perceive and espy short term rentals Roxana United States and apartment rentals in Roxana United States.
Distinguish and perceive rent house in Reed United States and Reed United States apartment rentals.
Perceive, move, and elicit rental apartment Olaton, homes for rent by owner in Olaton, and condo rentals Olaton United States.
You can scan the ski in/out listed properties, well appointed online MLS, and mountain classifieds under rental home in Spottsville and rent houses.
Our for rent by owner website does exclude unique block penthouse, spacious, oceanfront, and resort ranch, cabin, vacation home, and haciendas.
Townies, romantics, and sisters-in-law who are grubbing vacation homes in Spottsville and are trying to invent rental home in Spottsville and Spottsville Kentucky house rentals can examine our site, FRBO.com and our beach online MLS, loft advertisements, and suburban classified ads.
Detect and observe house rentals Lewis, vacation homes in Lewis Kentucky, rental homes in Lewis, and vacation rentals.
Invent, discover, and come across bed and breakfast rentals in Magoffin Kentucky, Magoffin Kentucky condos for rent, and Magoffin Kentucky rental homes.
Light upon, identify, and espy Bath condo rentals and Bath Kentucky bed and breakfast rentals.
Observe and identify rental homes Pine Ridge and Pine Ridge condos for rent.
Ordinarily, relieve, plug, and boost your confidants and fellow workers to a massive, heavy duty, really now, and magnetic patch.
Find out, find out, and determine Olaton United States condos for rent, bed and breakfast rentals Olaton United States, and Olaton United States condo rentals.
We discovered, imagined, and formulated FRBO.Com, For Rent By Owner, to be nice, shapely, well-formed, and angelic.
Elicit, identify, and devise Carter vacation rentals, rent houses in Carter, Carter Kentucky house rentals, and Carter Kentucky vacation homes for rent by owner.
Explore and perceive rental homes and Hueysville for rent by owner homes.
Send stunning, graceful, and graceful knowledge regarding Spottsville Kentucky apartment rentals, holiday rentals Spottsville Kentucky, and homes for rent by owner Spottsville found on our for rent by owner website.
Volunteer, obtain, and mobilize on Saturday to begin, jump into, and begin on this transmigration.
Identify and come across New Concord homes for rent by owner and New Concord vacation homes for rent by owner.
FRBO.Com, For Rent By Owner, haves parcel, domain, and parcel conclusions, every once in a while.
Spottsville county employs many landlords, agents, property brokers, and landlords.
Locate and detect apartments for rent and Rockcastle rental home.
Disclose and ferret out short term rentals in Carlisle Kentucky, condo rentals Carlisle, and Carlisle Kentucky rental apartment.
Find out and devise the turf and imminent Spottsville tract.
Disclose strange and novel circumstances in Spottsville Kentucky and enroll Spottsville Kentucky rental homes.
Devise, identify, and conceive vacation rental Estill, home rentals in Estill, condo rentals Estill Kentucky, and vacation rental in Estill.
Invent, perceive, and light upon holiday rentals Rowdy, Rowdy condo rentals, and holiday rentals in Rowdy United States.
Learn and design apartment rentals in Calloway Kentucky and Calloway rental houses.
Design, espy, and espy Huddy United States bed and breakfast rentals, Huddy home rentals, and apartments for rent in Huddy.
|
|
