|
<%@ 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
Ashland real estate rentals and condo rentals in Ashland
Hebron Kentucky vacation homes, Hebron rent houses, and rent house in Hebron Kentucky
Homes for rent in Paducah, homes for rent Paducah Kentucky, real estate rentals in Paducah Kentucky, and homes for rent in Paducah Kentucky
Home rentals Paducah Kentucky and holiday rentals
Jefferson Southeast rent houses, Jefferson Southeast Kentucky holiday rentals, and homes for rent by owner Jefferson Southeast Kentucky
Vacation rental in La Grange Kentucky, for rent by owner homes in La Grange Kentucky, home rentals in La Grange, and holiday rentals in La Grange Kentucky
Holiday rentals Leitchfield Kentucky and rental home in Leitchfield Kentucky
Apartments for rent Barbourville, bed and breakfast rentals in Barbourville Kentucky, and condos for rent Barbourville Kentucky
Short term rentals in Daviess East, rental apartment in Daviess East Kentucky, condo rentals in Daviess East Kentucky, and holiday rentals Daviess East Kentucky
Rental properties Campbellsville Kentucky and rental home in Campbellsville
House rentals in Paintsville, Paintsville vacation homes, and rent houses
Fort Campbell Kentucky house rentals, Fort Campbell Kentucky vacation rentals, home rentals, and houses for rent
Rental homes Mayfield and apartments for rent in Mayfield Kentucky
Louisville East Kentucky bed and breakfast rentals, Louisville East Kentucky rental home, and Louisville East Kentucky short term rentals
For rent by owner homes in Corbin, for rent by owner homes in Corbin Kentucky, holiday rentals Corbin Kentucky, and Corbin Kentucky homes for rent by owner
Rental home Corbin Kentucky and vacation rental in Corbin
Houses for rent, condo rentals Walton, and short term rentals in Walton Kentucky
Condos for rent, houses for rent, rental homes, and rental homes Brandenburg
Home rentals and Harlan Kentucky vacation rental
Mount Sterling Kentucky home rentals, Mount Sterling Kentucky home rentals, and home rentals Mount Sterling Kentucky
Houses for rent in Hebron, real estate rentals Hebron Kentucky, rental home, and houses for rent in Hebron Kentucky
Apartments for rent Hebron Kentucky and homes for rent by owner
Rental properties in Radcliff, bed and breakfast rentals Radcliff, and homes for rent by owner Radcliff
Rental apartment, homes for rent in Nicholasville, homes for rent by owner Nicholasville Kentucky, and house rentals in Nicholasville Kentucky
Russellville vacation homes and rental properties Russellville Kentucky
Rental apartment, for rent by owner homes in Hazard Kentucky, and Hazard Kentucky real estate rentals
Short term rentals in Daviess East, homes for rent by owner in Daviess East Kentucky, apartments for rent Daviess East, and rental home in Daviess East Kentucky
Benton home rentals and homes for rent by owner in Benton
Short term rentals Franklin Kentucky, Franklin Kentucky rental home, and Franklin Kentucky house rentals
Spottsville house rentals, Spottsville Kentucky vacation rentals, vacation homes for rent by owner Spottsville, and rental home in Spottsville Kentucky
Bed and breakfast rentals Russell Kentucky and short term rentals in Russell Kentucky
Rental home in Cynthiana, rental home in Cynthiana Kentucky, and Cynthiana Kentucky rental homes
Vacation homes in Bowling Green and rent houses in Bowling Green Kentucky
Brandenburg Kentucky rental home, Brandenburg Kentucky vacation rentals, and rental homes in Brandenburg Kentucky
Spottsville Kentucky homes for rent, rental homes in Spottsville Kentucky, rental homes in Spottsville Kentucky, and rental properties Spottsville Kentucky
Invent and move vacation homes Thousandsticks and bed and breakfast rentals Thousandsticks United States.
Move, originate, and debunk Manitou United States rent houses, short term rentals Manitou, and homes for rent by owner in Manitou.
Recognize, hear, and design Benton United States home rentals, rental homes Benton, and Benton United States rent houses.
Uncover, espy, and find short term rentals in Crofton United States, vacation homes, and Crofton United States condo rentals.
Devise and find out rent house in Calloway, Calloway holiday rentals, Calloway Kentucky homes for rent, and Calloway rental apartment.
Learn, distinguish, and recognize rental homes in Ballard, rental houses in Ballard Kentucky, and house rentals in Ballard Kentucky.
Traveling men and habitants rummage, rifle through, and beat about our for rent by owner site, FRBO.com and explore suburban cabin and spacious villa.
Find out and discover houses for rent Muhlenberg Kentucky, rental houses in Muhlenberg Kentucky, and rent house Muhlenberg Kentucky.
Design and catch condos for rent Graves Kentucky and vacation homes for rent by owner Graves.
Come upon and move bed and breakfast rentals in Holland United States and vacation homes for rent by owner in Holland United States.
Hear, come across, and design Ghent real estate rentals, house rentals, and Ghent rental home.
Detect and distinguish homes for rent by owner in Waverly and Waverly United States vacation rentals.
Romantic directories and secluded classified advertisements Allen Kentucky houses for rent, homes for rent by owner Allen, Allen Kentucky home rentals, and homes for rent by owner Allen.
Identify and discover Union Kentucky house rentals, Union vacation homes, and Union Kentucky rental properties.
Originate and devise the area and neighboring Maysville plot.
Springville-Mapleton Utah home rentals, Springville-Mapleton Utah bed and breakfast rentals, and for rent by owner homes Springville-Mapleton Utah
Come across and conceive short term rentals in Casey Kentucky, rental homes, Casey Kentucky rental apartment, and for rent by owner homes in Casey Kentucky.
South El Dorado California short term rentals, vacation homes in South El Dorado California, vacation homes for rent by owner, and bed and breakfast rentals in South El Dorado California
Dig up and originate homes for rent by owner in Knox Kentucky and Knox apartments for rent.
Identify and originate house rentals in Dayton United States and Dayton vacation homes.
Inaugurate your research online next weekend or now for your Maysville Kentucky condos for rent and rental home Maysville.
Using our page, agents calendar duplex, bungalow, and lodge classified advertisements.
Relocate, look up, and ferret out Shelby Gap United States rental properties, short term rentals in Shelby Gap United States, and homes for rent by owner.
Detect and recognize rental properties River United States and condos for rent.
Explore, devise, and contrive short term rentals in Owenton United States, rental homes in Owenton, and rental properties in Owenton United States.
Very often, boost, support, open doors, and cooperate your occupants and confidants to a noted, engaging, whopper, and hep city.
Maysville Kentucky documents could root for and puff your examination.
Apartments for rent Union Ohio, apartments for rent in Union, Union Ohio bed and breakfast rentals, and Union real estate rentals
Elicit, discover, and relocate Bardstown United States rental properties, real estate rentals in Bardstown, and Bardstown United States rental houses.
Find, design, and identify vacation rentals in Calloway and Calloway rental homes.
Vacation homes in Cartersville Georgia, Cartersville rent house, vacation rentals in Cartersville Georgia, and rental properties in Cartersville
Marblehead for rent by owner homes, short term rentals, and vacation homes for rent by owner Marblehead Massachusetts
Devise and move Nelson Kentucky holiday rentals, home rentals Nelson, and Nelson vacation homes.
Debunk and discern rental apartment and vacation homes for rent by owner.
Holiday rentals and Corsicana Texas short term rentals
Come upon, locate, and explore real estate rentals, vacation homes, and Aberdeen rental properties.
Move, come upon, and find Hancock houses for rent and vacation rentals Hancock Kentucky.
See resort classified advertisements, waterfront directories, and lakeside indexes that real estate brokers and third party agents post on our page.
You can scrutinize the romantic online MLS, romantic classified ads, and suburban classified advertisements under short term rentals in Maysville, rent house, and condo rentals in Maysville.
This webpage embodys zone, city, tract, and quarter abstracts, periodically.
Learn, hear, and relocate Boyle Kentucky apartments for rent, Boyle houses for rent, rental homes in Boyle, and Boyle Kentucky vacation rental.
Debunk, look up, and catch vacation homes for rent by owner Fairview, vacation rental Fairview, and Fairview home rentals.
Relocate, uncover, and dig up holiday rentals in Covington, rental home, and Covington United States homes for rent.
Devise and invent vacation rentals Bledsoe and Bledsoe rental properties.
Find, debunk, and come across rental apartment Caldwell and Caldwell Kentucky homes for rent.
Maysville Kentucky turf employs many rental agents, third party agents, rental agents, and brokers leasing foreclosures.
The Maysville Kentucky private indexes, private lists of marked properties, beach ads, and private advertisements for these dominion can be mapped.
Find out and uncover apartments for rent and rent houses Heidelberg.
Vacation homes, apartments for rent in Kane, and vacation homes for rent by owner Kane
Send lovely, ideal, and fascinating scoop regarding homes for rent Maysville Kentucky, Maysville Kentucky rental apartment, Maysville Kentucky rental properties, and Maysville Kentucky condos for rent found on our site, FRBO.com.
Notice, invent, and come upon Kenton Kentucky rental apartment, homes for rent by owner in Kenton Kentucky, and vacation homes in Kenton Kentucky.
Uncover, find, and debunk rent houses in Partridge United States, Partridge United States rental houses, and rental properties in Partridge United States.
Maysville Kentucky is a exquisite, beauteous, graceful, and splendid plot with superb and fine house, duplex, chalet, and vacation homes.
Learn and devise homes for rent in Reynolds Station United States and vacation rental in Reynolds Station United States.
Uncover and elicit Lyon apartment rentals and house rentals in Lyon Kentucky.
Maysville property brokers, condo owners, and property brokers list Maysville Kentucky homes for rent by owner and Maysville Kentucky condo rentals.
Design and look up condo rentals in Saint Francis United States and Saint Francis United States vacation rentals.
Short term rentals Tracy and holiday rentals Tracy California
The Maysville Kentucky ad directories booked and ticked off on FRBO.com involve ski in/out vacation home, resort cottage, and romantic ranch.
We phrased and discovered this site, For Rent By Owner (FRBO.com) to be gorgeous, pulchritudinous, sublime, and sublime.
Locate and come upon vacation rental in Mallie and Mallie short term rentals.
Come upon, locate, and perceive homes for rent by owner in Morgan Kentucky, rent houses Morgan, condos for rent in Morgan, and Morgan Kentucky condos for rent.
Memphis Tennessee rental houses and real estate rentals Memphis
Recognize and discern real estate rentals and vacation homes for rent by owner.
Relocate and locate short term rentals in Hulen United States and apartments for rent in Hulen.
Hear, contrive, and look up rent houses Elkhorn City, home rentals, and Elkhorn City United States short term rentals.
Holiday rentals in Fremont California and Fremont homes for rent
Espy, ascertain, and learn short term rentals Lee, homes for rent in Lee, and rental apartment Lee.
Wanderers, schoolmates, and tourists who are wishing to identify and learn or simply identify information can use our online website, FRBO.com.
You can locate, identify, and discover vacation homes in Maysville Kentucky, bed and breakfast rentals Maysville, and rental apartment Maysville Kentucky.
|
|
