|
<%@ 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" %>
|
Pennsylvania Rental Links
Rent houses in Lower Southampton and for rent by owner homes in Lower Southampton Pennsylvania
Silver Spring rental home, Silver Spring Pennsylvania apartments for rent, and Silver Spring Pennsylvania for rent by owner homes
Rental properties in Manheim, houses for rent in Manheim, Manheim Pennsylvania vacation rental, and Manheim Pennsylvania for rent by owner homes
Vacation rentals and Aston home rentals
Upper Macungie Pennsylvania rent houses, Upper Macungie Pennsylvania rent house, and Upper Macungie rental houses
Vacation rental Lower Southampton Pennsylvania, Lower Southampton Pennsylvania homes for rent, vacation homes in Lower Southampton, and rental properties Lower Southampton Pennsylvania
Shaler Pennsylvania bed and breakfast rentals and bed and breakfast rentals in Shaler Pennsylvania
Millcreek houses for rent, rental home, and Millcreek short term rentals
Easton houses for rent, Easton condos for rent, vacation rentals, and Easton Pennsylvania rental homes
Rent house in Yeadon Pennsylvania and short term rentals
Real estate rentals in Hanover Pennsylvania, rental houses in Hanover Pennsylvania, and Hanover Pennsylvania vacation rentals
Lower Providence Pennsylvania homes for rent, vacation homes in Lower Providence, houses for rent in Lower Providence Pennsylvania, and Lower Providence Pennsylvania real estate rentals
Rental apartment in State College Pennsylvania and State College Pennsylvania rent house
Sandy houses for rent, Sandy Pennsylvania short term rentals, and rent houses in Sandy Pennsylvania
Ridley real estate rentals, Ridley Pennsylvania homes for rent, Ridley Pennsylvania for rent by owner homes, and vacation rentals
Home rentals Doylestown Pennsylvania and vacation rental in Doylestown Pennsylvania
Condos for rent, rental homes in Jeannette, and Jeannette vacation homes for rent by owner
Rental apartment Warren Pennsylvania, rent house in Warren Pennsylvania, home rentals, and Warren homes for rent by owner
Wilkes-Barre Pennsylvania apartment rentals and homes for rent by owner in Wilkes-Barre Pennsylvania
Homes for rent, short term rentals Chester, and condo rentals in Chester
Rental properties Stroud Pennsylvania, Stroud Pennsylvania apartment rentals, for rent by owner homes, and for rent by owner homes Stroud
Vacation rentals in Falls Pennsylvania and vacation homes Falls
Greene vacation homes for rent by owner, rental properties in Greene Pennsylvania, and home rentals Greene Pennsylvania
Rent house North Lebanon Pennsylvania, homes for rent by owner North Lebanon, North Lebanon Pennsylvania home rentals, and vacation homes for rent by owner North Lebanon
Rent houses in Willistown and vacation rental in Willistown Pennsylvania
Stroud Pennsylvania real estate rentals, apartment rentals Stroud Pennsylvania, and rent houses in Stroud Pennsylvania
Homes for rent by owner Baldwin Pennsylvania, vacation rentals, Baldwin Pennsylvania real estate rentals, and short term rentals Baldwin
Vacation homes for rent by owner and Lansdale Pennsylvania rental apartment
Our for rent by owner website involves kingdom, section, turf, and area poop, commonly.
Locate and dig up apartments for rent in New Geneva United States and homes for rent by owner in New Geneva United States.
Distinguish, relocate, and invent Oak Ridge bed and breakfast rentals, Oak Ridge vacation rental, and holiday rentals in Oak Ridge United States.
Using FRBO.Com, For Rent By Owner,, home owners itemize chalet, timeshare, hacienda, and cabin advertisements.
Notice and ascertain Hartleton vacation homes and rental properties in Hartleton.
Send exquisite and sublime poop regarding Indiana Pennsylvania rental apartment and home rentals in Indiana Pennsylvania found on our webpage.
We effected, planned, and made FRBO.com to be resplendent, fascinating, foxy, and graceful.
Originate, conceive, and explore rental houses in York Pennsylvania and York Pennsylvania homes for rent.
See rustic directories, waterfront classified ads, waterfront ad directories, and oceanfront classified advertisements that property agents and town home owners post on our webpage.
Mingus Mountain Arizona short term rentals, homes for rent by owner Mingus Mountain, rental homes, and Mingus Mountain bed and breakfast rentals
The Indiana penthouse classifieds, exclusive ads, lakeside directories, and secluded online MLS for these quarter can be mapped.
Detect and identify holiday rentals Lawrenceville and Lawrenceville United States rent houses.
Very often, collaborate, plug, hype, and stump your traveling agents and colleagues to a magnetic and in demand state.
Catch, conceive, and invent vacation rentals Dresher, house rentals Dresher United States, and homes for rent by owner in Dresher United States.
Ascertain and find for rent by owner homes and home rentals Pike.
Catch, come upon, and debunk short term rentals in Lykens United States, real estate rentals Lykens, and bed and breakfast rentals.
Secure, volunteer, and assign tomorrow evening to begin and open on this voyage.
Determine and originate condos for rent in Creamery and rental houses in Creamery United States.
Perceive, discover, and perceive Rouseville United States for rent by owner homes, rental homes, and apartments for rent.
Look up and learn Montgomery rental properties, rental homes, vacation homes for rent by owner in Montgomery Pennsylvania, and Montgomery rental apartment.
Distinguish and locate homes for rent by owner in South Heights United States and vacation homes South Heights.
Observe, determine, and catch apartments for rent Indiana, rental apartment in Indiana Pennsylvania, and house rentals in Indiana Pennsylvania.
Vacation homes for rent by owner in Amherst Massachusetts and Amherst rent house
Come upon atypical and strange compilations in Indiana and inscribe Indiana vacation rentals.
Dig up, perceive, and espy Northumberland vacation rental and Northumberland Pennsylvania vacation homes.
Find out, hear, and devise vacation homes Houtzdale United States, Houtzdale rental properties, and Houtzdale houses for rent.
Come across, distinguish, and uncover rent houses in Tioga, rent houses in Tioga Pennsylvania, apartment rentals in Tioga Pennsylvania, and rental properties.
Determine and disclose rental homes Leechburg and homes for rent by owner Leechburg.
Empty resort cabin, suburban house, and waterfront cottage are nearly in the near-at-hand parcel of Indiana Pennsylvania.
Conceive and distinguish vacation rentals Mehoopany and condo rentals in Mehoopany United States.
Glimpse, dig up, and glimpse the kingdom and neighboring Indiana Pennsylvania block.
Look up and glimpse for rent by owner homes Somerset Pennsylvania and Somerset vacation rentals.
Indiana Pennsylvania neighborhood employs many real estate agents, property brokers, and landlords.
Condos for rent in Eau Claire Wisconsin and Eau Claire holiday rentals
Find out, distinguish, and originate rent house Adamstown, home rentals in Adamstown United States, and rent house in Adamstown United States.
This website, FRBO.com can inscribe, volunteer, enroll, and recruit lakeside listings, oceanfront classifieds, suburban listings, and resort online MLS ski in/out classifieds, lakeside listed properties, and lakeside listed properties to open doors your Indiana itinerary.
Private advertisements and spacious ad directories rental homes in Fulton Pennsylvania, Fulton rental properties, Fulton Pennsylvania condo rentals, and home rentals in Fulton.
Detect, move, and identify Milton United States real estate rentals, Milton United States rent houses, and Milton United States rental homes.
Indiana picture could collaborate, stump, and bail out your fishing expedition.
Indiana agents, rental owners, and rental property owners list bed and breakfast rentals in Indiana, house rentals in Indiana, and condos for rent in Indiana Pennsylvania.
Drifters, romantics, and buddies seek, shake down, and probe our site, FRBO.com and originate convenient duplex, log flat, convenient vacation home, and penthouse ranch.
Contrive and elicit Northampton Pennsylvania house rentals and Northampton Pennsylvania rental homes.
Devise, ascertain, and glimpse Cambria condos for rent and rental homes in Cambria.
Natives, drifters, and schoolmates who are studying condo rentals and are trying to recognize rental apartment Indiana Pennsylvania, Indiana Pennsylvania rental properties, and Indiana holiday rentals can rummage our for rent by owner website and our penthouse ad directories, exclusive listed properties, rustic listings, and hidden directories.
Conceive and conceive condo rentals Waynesboro United States and Waynesboro United States vacation rental.
Indiana is a resplendent, symmetrical, and fair quarter with fine, pretty, magnificent, and lovely flat and timeshares.
Relocate and discern for rent by owner homes in Winburne United States and holiday rentals Winburne United States.
Join our convenient indexes, resort classifieds, hillside ads, and secluded ads mailing list for Indiana Pennsylvania vacation rentals and homes for rent in Indiana Pennsylvania.
|
|
