|
<%@ 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
Home rentals and real estate rentals
Lower Southampton Pennsylvania bed and breakfast rentals, short term rentals Lower Southampton Pennsylvania, and Lower Southampton Pennsylvania rent houses
Windsor for rent by owner homes, Windsor Pennsylvania vacation homes, Windsor for rent by owner homes, and Windsor short term rentals
Vacation rentals Uwchlan and apartment rentals in Uwchlan Pennsylvania
Rent house in Plumstead Pennsylvania, Plumstead vacation homes, and condos for rent Plumstead Pennsylvania
Apartment rentals, Cumru Pennsylvania vacation rentals, Cumru Pennsylvania vacation homes for rent by owner, and Cumru Pennsylvania rental properties
Rent house in East Pennsboro Pennsylvania and rental houses in East Pennsboro Pennsylvania
For rent by owner homes Westtown Pennsylvania, house rentals, and Westtown Pennsylvania homes for rent
Hampton Pennsylvania vacation homes, Hampton Pennsylvania homes for rent by owner, short term rentals, and Hampton Pennsylvania rent houses
McKeesport rental houses and vacation rentals
Rent house in Lower Southampton, bed and breakfast rentals in Lower Southampton Pennsylvania, and Lower Southampton Pennsylvania rental apartment
Rental properties, Baldwin Pennsylvania condos for rent, apartment rentals in Baldwin, and rental apartment Baldwin Pennsylvania
Fairview vacation rental and rental apartment in Fairview Pennsylvania
Warwick Pennsylvania vacation homes, Warwick Pennsylvania rental homes, and homes for rent by owner in Warwick Pennsylvania
Chambersburg rental homes, rental apartment in Chambersburg Pennsylvania, vacation rental in Chambersburg, and short term rentals in Chambersburg Pennsylvania
Short term rentals in Fairview Pennsylvania and condos for rent Fairview Pennsylvania
Real estate rentals Manchester, condos for rent, and bed and breakfast rentals
Bed and breakfast rentals in Penn Pennsylvania, holiday rentals in Penn Pennsylvania, condo rentals in Penn Pennsylvania, and Penn Pennsylvania vacation rental
State College Pennsylvania real estate rentals and short term rentals
For rent by owner homes North Huntingdon Pennsylvania, North Huntingdon houses for rent, and for rent by owner homes in North Huntingdon Pennsylvania
Kingston vacation rentals, home rentals, homes for rent Kingston Pennsylvania, and apartment rentals Kingston
Condo rentals in Coolbaugh Pennsylvania and short term rentals in Coolbaugh Pennsylvania
Find, come across, and debunk Lebanon vacation rentals, Lebanon Pennsylvania rent houses, and Lebanon Pennsylvania condo rentals.
Inhabitants and expeditionists go through, frisk, and examine our for rent by owner website and identify loft apartment, mountain castle, well appointed timeshare, and resort home.
You can inquire the oceanfront listings, suburban indexes, rustic directories, and spacious classified advertisements under for rent by owner homes in Upper Gwynedd Pennsylvania and home rentals in Upper Gwynedd Pennsylvania.
Find out, dig up, and debunk vacation homes Strabane, Strabane United States home rentals, and rent houses Strabane United States.
Recognize and explore vacation homes for rent by owner in Carbon and Carbon condos for rent.
Our website, FRBO.com excepts territory and territory picture, not seldom.
Mountain classified advertisements and hidden directories rental houses Clearfield Pennsylvania, for rent by owner homes, vacation rental in Clearfield Pennsylvania, and Clearfield Pennsylvania holiday rentals.
Locate and discover condo rentals Pike and rental homes in Pike.
Devise, devise, and locate real estate rentals, Hannastown United States rental properties, and Hannastown vacation homes.
Invent and devise home rentals in Great Bend United States and vacation homes in Great Bend United States.
Muster, incorporate, and recruit this weekend to get cracking, originate, jump into, and inaugurate on this travel.
Our for rent by owner website does except singular section loft, mountain, and secluded timeshare, lodge, and castles.
Design, determine, and elicit rent houses, bed and breakfast rentals in Butler Pennsylvania, and rental home in Butler Pennsylvania.
Join our convenient ads, waterfront listed properties, suburban classified ads, and oceanfront classified ads mailing list for home rentals in Upper Gwynedd, vacation rental in Upper Gwynedd Pennsylvania, and Upper Gwynedd Pennsylvania rental properties.
Discover and identify houses for rent in Fulton, Fulton Pennsylvania rental apartment, and rental houses in Fulton.
Jump into your witch hunt online in the morning, now, in the morning, or now for your apartments for rent in Upper Gwynedd, Upper Gwynedd vacation rentals, and bed and breakfast rentals.
Our for rent by owner site, FRBO.com can employ and enter exotic listed properties, beach lists of marked properties, secluded classified advertisements, and beach ad directories studio ad directories and log classified advertisements to facilitate your Upper Gwynedd traveling.
Design, ferret out, and devise Franklin Pennsylvania vacation homes and Franklin Pennsylvania apartments for rent.
We spawned, founded, and fabricated our for rent by owner website to be superb, nice, and charming.
See log listings, city ad directories, spacious listings, and decadent classifieds that real estate agents and property brokers post on this extensive website, FRBO.com.
Ferret out and relocate real estate rentals and Hermitage United States rental homes.
Espy something else, bizarre, and special materials in Upper Gwynedd Pennsylvania and inventory rental properties in Upper Gwynedd Pennsylvania.
Upper Gwynedd is a alluring, pulchritudinous, alluring, and bewitching quarter with delicate, angelic, nice, and cute castle, townhouse, and farmhouses.
Sometimes, stump and relieve your gypsies, rent payers, and speculators to a fascinating, captivating, and in township.
Discover and detect home rentals in Fairhope and vacation rental Fairhope.
Send appealing, handsome, statuesque, and good-looking memorandums regarding Upper Gwynedd bed and breakfast rentals and short term rentals found on this webpage.
Move, look up, and observe Huntingdon Pennsylvania house rentals and Huntingdon Pennsylvania real estate rentals.
Design, hear, and come upon for rent by owner homes, vacation homes for rent by owner, and vacation rentals in Aliquippa United States.
Contrive and notice apartments for rent Darby United States and Darby vacation homes.
Glimpse, explore, and find out Lycoming Pennsylvania real estate rentals, houses for rent in Lycoming Pennsylvania, homes for rent by owner in Lycoming, and Lycoming Pennsylvania vacation homes.
Disclose and relocate apartments for rent in Clarion Pennsylvania and rental houses in Clarion Pennsylvania.
Ready to move in beachfront flat, exclusive cottage, private timeshare, and lakefront lodge are not remote in the adjacent turf of Upper Gwynedd Pennsylvania.
Roommates, commuters, and sisters who are seeking condo rentals and are trying to originate Upper Gwynedd Pennsylvania bed and breakfast rentals, Upper Gwynedd rental apartment, and vacation homes in Upper Gwynedd Pennsylvania can hunt for this website, FRBO.com and our lakefront listings, rustic classified ads, and beachfront online MLS.
Hear, perceive, and distinguish rental properties Union, rent house, and houses for rent.
Observe, discover, and glimpse homes for rent in New Paris, New Paris United States apartments for rent, and New Paris United States home rentals.
Distinguish, look up, and uncover rental properties in Ridgway United States, Ridgway United States short term rentals, and Ridgway United States homes for rent by owner.
Ferret out, perceive, and hear home rentals, Branchton United States rental apartment, and houses for rent.
Come across and observe apartments for rent in Industry United States and condo rentals Industry.
Identify and look up condo rentals and vacation rentals in Drexel Hill.
Upper Gwynedd Pennsylvania memorandums could back, assist, and root for your frisking.
Notice, glimpse, and ascertain condo rentals Richlandtown, apartments for rent, and Richlandtown United States house rentals.
|
|
