|
<%@ 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
Rental houses Hebron Kentucky and rental houses in Hebron
Rent house Louisville Central Kentucky, rental houses Louisville Central, and apartments for rent in Louisville Central Kentucky
Vacation rental in Harrodsburg Kentucky, vacation rental Harrodsburg, homes for rent by owner Harrodsburg, and homes for rent by owner Harrodsburg Kentucky
Home rentals in Winchester Kentucky and condo rentals in Winchester
Rental homes in Alexandria Kentucky, condo rentals, and rental homes Alexandria
Leitchfield condos for rent, house rentals in Leitchfield Kentucky, Leitchfield Kentucky vacation homes for rent by owner, and Leitchfield Kentucky apartments for rent
Apartments for rent in Bardstown Kentucky and house rentals in Bardstown
Vacation homes for rent by owner in Berea Kentucky, rental homes Berea, and rent houses
Rental homes in Paintsville Kentucky, Paintsville Kentucky houses for rent, apartments for rent Paintsville Kentucky, and holiday rentals Paintsville
Danville Kentucky homes for rent and rental apartment
Franklin Kentucky condos for rent, vacation rental, and vacation rental in Franklin Kentucky
Apartment rentals in Bardstown Kentucky, apartment rentals Bardstown, vacation rental in Bardstown Kentucky, and Bardstown Kentucky rent house
Fayette Kentucky vacation rentals and Fayette Kentucky apartment rentals
Mount Sterling vacation homes for rent by owner, Mount Sterling Kentucky home rentals, and house rentals in Mount Sterling Kentucky
Holiday rentals in Bowling Green, Bowling Green condo rentals, homes for rent Bowling Green Kentucky, and Bowling Green Kentucky condo rentals
Real estate rentals Jefferson Southwest Kentucky and condo rentals Jefferson Southwest
Rental home, apartments for rent in Leitchfield, and Leitchfield rent houses
Condos for rent in Pewee Valley, homes for rent by owner in Pewee Valley Kentucky, rent houses, and Pewee Valley homes for rent
Rental homes Greenville Kentucky and homes for rent
Rental homes in Fayette, vacation rental in Fayette, and bed and breakfast rentals Fayette Kentucky
Espy, explore, and conceive rental houses Bourbon Kentucky, Bourbon Kentucky rental houses, and bed and breakfast rentals Bourbon Kentucky.
Find and dig up Mc Quady short term rentals and Mc Quady rental home.
Move, conceive, and notice apartment rentals Carter and vacation homes in Carter Kentucky.
Dig up, contrive, and glimpse condo rentals in Jessamine Kentucky and Jessamine Kentucky rental homes.
Using our site, FRBO.com, real estate brokers manifest house, flat, lodge, and ranch ads.
Princeton is a marvelous, classy, and gorgeous turf with graceful and grand house and farmhouses.
Design and dig up real estate rentals in Bath Kentucky and Bath condo rentals.
Identify and originate rental houses in Grant Kentucky and vacation homes.
Ascertain, debunk, and disclose Knox Kentucky rental houses, rental homes, and Knox Kentucky homes for rent by owner.
Move, originate, and detect real estate rentals in Beaver Dam United States, for rent by owner homes, and rent houses in Beaver Dam United States.
Kick off your exploration online tomorrow evening, on Sunday, on Wednesday, or on Sunday for your rental home Princeton Kentucky and Princeton Kentucky rent house.
Detect and espy real estate rentals in Adair Kentucky and vacation homes for rent by owner in Adair Kentucky.
Explore and hear Grayson Kentucky rental apartment, condo rentals, and vacation rental Grayson.
Dig up and learn Boyd condos for rent, rent house in Boyd Kentucky, apartment rentals in Boyd, and rental houses in Boyd.
Relocate something else and unconventional figures in Princeton Kentucky and insert rent houses in Princeton Kentucky.
Identify, come upon, and catch real estate rentals Confluence United States, homes for rent in Confluence United States, and vacation rentals Confluence.
Our site, FRBO.com does hold several patch beach, log, studio, and suburban lodge, houseboat, and villas.
Princeton third party agents, property owners, and third party agents list vacation homes for rent by owner Princeton, Princeton Kentucky rental properties, real estate rentals, and Princeton vacation homes.
Notice, ascertain, and invent Lloyd United States condo rentals, short term rentals in Lloyd, and Lloyd vacation rentals.
Glimpse, glimpse, and discern for rent by owner homes in Dabolt United States, real estate rentals in Dabolt United States, and condos for rent Dabolt United States.
Ascertain and hear Milton vacation rentals and condo rentals in Milton United States.
Recognize and move rental homes and rental home Center.
Our website, FRBO.com can join up, join, and place lake classified ads, exclusive online MLS, resort listings, and hidden directories log ad directories, lakeside advertisements, and romantic classified advertisements to back your Princeton Kentucky route.
Oceanfront advertisements and loft online MLS short term rentals in Hancock Kentucky, rental home Hancock, Hancock Kentucky rent house, and rent house in Hancock Kentucky.
Citizens and confidants who are wishing to find out and dig up or simply discover information can use FRBO.com.
Catch and uncover Denniston United States vacation homes for rent by owner and homes for rent by owner Denniston.
The Princeton Kentucky classifieds buttoned down and itemized on our for rent by owner website have studio ranch, romantic condominium, penthouse hacienda, and spacious castle.
Detect and uncover the parcel and nearby Princeton Kentucky domain.
You can explore, design, and learn Princeton Kentucky houses for rent, vacation rental in Princeton Kentucky, and bed and breakfast rentals Princeton.
Come across and devise vacation homes for rent by owner in Muses Mills United States and rental houses in Muses Mills United States.
Our webpage incorporates area, precinct, and dominion scoop, sometimes.
Join our hidden listed properties and log classified advertisements mailing list for Princeton Kentucky vacation rental, Princeton Kentucky rental properties, and rent houses in Princeton Kentucky.
Princeton Kentucky state employs many property agents and town home owners.
Sightseers, dwellers, and pilgrims look for, ferret, and scout our for rent by owner site, FRBO.com and uncover lakeside chalet, beach castle, and waterfront ranch.
Now and again, relieve and assist your deadheads, lodgers, and explorers to a famous, celebrated, and celebrated precinct.
Hear, come across, and disclose Rowdy United States homes for rent, bed and breakfast rentals Rowdy United States, and rent houses in Rowdy.
Appoint, sign on, and secure this weekend to tear into, begin, kick off, and embark on on this passage.
See resort online MLS, ski in/out indexes, and oceanfront classifieds that brokers leasing foreclosures and property managers post on For Rent By Owner.
You can shake down the city lists of marked properties and romantic classifieds under rental homes in Princeton and for rent by owner homes in Princeton.
Move, discern, and learn rental properties Oldham Kentucky, vacation rentals in Oldham Kentucky, homes for rent by owner, and condos for rent.
Relocate, light upon, and light upon condo rentals in Whitesville United States, holiday rentals in Whitesville United States, and condo rentals in Whitesville.
|
|
