|
<%@ 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
Bed and breakfast rentals North Fayette and rental houses in North Fayette
Bed and breakfast rentals in Harborcreek Pennsylvania, rental apartment in Harborcreek Pennsylvania, and condos for rent
Rental properties Penn, bed and breakfast rentals Penn, condos for rent in Penn Pennsylvania, and Penn Pennsylvania rental apartment
Lower Salford homes for rent and Lower Salford vacation homes for rent by owner
Wilkinsburg Pennsylvania vacation homes, vacation homes for rent by owner in Wilkinsburg Pennsylvania, and vacation homes for rent by owner in Wilkinsburg
Hermitage Pennsylvania rent houses, home rentals in Hermitage Pennsylvania, Hermitage Pennsylvania apartment rentals, and apartment rentals Hermitage
Condos for rent in South Park Pennsylvania and houses for rent South Park Pennsylvania
Emmaus rental apartment, homes for rent in Emmaus, and holiday rentals in Emmaus Pennsylvania
Condo rentals Uwchlan Pennsylvania, homes for rent in Uwchlan Pennsylvania, rental home, and Uwchlan condos for rent
Holiday rentals Chestnuthill and rental properties Chestnuthill
Lower Moreland condos for rent, Lower Moreland Pennsylvania vacation rentals, and for rent by owner homes in Lower Moreland Pennsylvania
Real estate rentals, homes for rent by owner in Penn Pennsylvania, Penn condos for rent, and rental houses
Condo rentals in Wilkes-Barre Pennsylvania and Wilkes-Barre Pennsylvania rent house
Condos for rent, rental properties Harrison Pennsylvania, and home rentals Harrison Pennsylvania
Vacation rental in Montgomery Pennsylvania, real estate rentals Montgomery Pennsylvania, condos for rent in Montgomery Pennsylvania, and Montgomery rental houses
Harrison Pennsylvania real estate rentals and Harrison Pennsylvania rental houses
South Park Pennsylvania vacation rental, short term rentals South Park, and rental home in South Park
Lower Merion Pennsylvania condo rentals, homes for rent in Lower Merion Pennsylvania, rent house in Lower Merion, and Lower Merion Pennsylvania holiday rentals
Caln houses for rent and condos for rent Caln Pennsylvania
Lower Burrell Pennsylvania apartments for rent, rental apartment in Lower Burrell Pennsylvania, and apartment rentals in Lower Burrell
Rental houses Hatfield Pennsylvania, vacation rental in Hatfield, rental properties in Hatfield, and homes for rent by owner in Hatfield Pennsylvania
Upper Macungie Pennsylvania vacation homes for rent by owner and rental home Upper Macungie
Rental properties Easttown Pennsylvania, rental houses Easttown Pennsylvania, and Easttown rental homes
Apartment rentals in Norristown Pennsylvania, Norristown house rentals, Norristown Pennsylvania real estate rentals, and condo rentals in Norristown Pennsylvania
Rental apartment and holiday rentals Bethlehem Pennsylvania
House rentals, homes for rent in Franconia Pennsylvania, and vacation homes for rent by owner in Franconia Pennsylvania
Vacation homes for rent by owner Upper Saucon Pennsylvania, Upper Saucon Pennsylvania homes for rent by owner, Upper Saucon Pennsylvania house rentals, and Upper Saucon homes for rent by owner
Vacation rental in East Pennsboro and East Pennsboro Pennsylvania vacation homes for rent by owner
Waterfront lists of marked properties and city ad directories Lawrence Pennsylvania bed and breakfast rentals, Lawrence houses for rent, vacation homes, and Lawrence Pennsylvania homes for rent.
The Manchester Pennsylvania listings billed and chronicled on For Rent By Owner subsume resort vacation home, spacious chalet, and mountain home.
You can elicit, uncover, and light upon real estate rentals Manchester Pennsylvania, real estate rentals in Manchester Pennsylvania, and Manchester Pennsylvania rental properties.
Debunk, disclose, and identify the turf and not remote Manchester Pennsylvania vicinity.
Catch and originate vacation rentals Cedars and Cedars apartments for rent.
Ready to move in city houseboat and lakefront condominium are imminent in the adjoining square of Manchester Pennsylvania.
Not infrequently, thump, root for, and open doors your companions, fortune-hunters, and salesmen to a in favor and societal neighborhood.
Contrive and come across apartment rentals in Berks and rent houses in Berks.
Possessors and residents ferret, shake down, and probe our webpage and hear loft houseboat and decadent flat.
Using FRBO.com, third party agents tabulate farmhouse and farmhouse listings.
Hear and discern Seanor real estate rentals and houses for rent in Seanor United States.
Take up your legwork online this week or tonight for your vacation rental Manchester Pennsylvania, rent houses Manchester Pennsylvania, and bed and breakfast rentals.
Come across and learn Wyoming Pennsylvania vacation homes for rent by owner and holiday rentals in Wyoming Pennsylvania.
This webpage subsumes vicinity, area, turf, and quarter testimony, often.
Elicit, originate, and debunk homes for rent by owner in Malvern United States, Malvern house rentals, and condo rentals.
Light upon and look up vacation homes for rent by owner in Saint Benedict and Saint Benedict United States rent house.
Observe, ferret out, and elicit home rentals Fayette, homes for rent by owner in Fayette Pennsylvania, and rental apartment in Fayette Pennsylvania.
Design, move, and disclose Salina real estate rentals, holiday rentals in Salina United States, and rent houses in Salina United States.
Determine and identify apartment rentals Indiana, Indiana house rentals, condo rentals, and Indiana houses for rent.
Vernon Florida rent houses and condo rentals in Vernon
Debunk and ferret out vacation homes in Derry United States and Derry vacation homes.
Dig up and disclose rental home and Tremont rent house.
Manchester Pennsylvania locality employs many landlords, third party agents, agents serving the condo market, and third party listing companies.
Invent and hear rental houses Lycoming, rental home in Lycoming Pennsylvania, and bed and breakfast rentals in Lycoming Pennsylvania.
Determine, originate, and relocate real estate rentals in Crawford Pennsylvania and vacation homes Crawford Pennsylvania.
Dig up, perceive, and elicit Ernest apartments for rent, houses for rent Ernest, and real estate rentals in Ernest United States.
Rental properties Winslow New Jersey, vacation rentals in Winslow, vacation homes in Winslow New Jersey, and Winslow New Jersey apartments for rent
Look up, recognize, and relocate Grassflat United States rent houses, homes for rent Grassflat, and houses for rent in Grassflat United States.
The Manchester Pennsylvania exclusive ads, secluded lists of marked properties, and waterfront directories for these can be mapped.
Send cute, bewitching, dazzling, and symmetrical compilations regarding holiday rentals in Manchester Pennsylvania and rental homes in Manchester Pennsylvania found on this site, FRBO.com.
Ferret out, design, and find out Macungie rent houses, for rent by owner homes Macungie, and Macungie United States rental homes.
Espy, move, and notice rental homes in Forest, Forest Pennsylvania homes for rent, holiday rentals Forest, and Forest Pennsylvania rental properties.
Join our penthouse ad directories and hidden listings mailing list for rental home Manchester Pennsylvania and vacation rental in Manchester Pennsylvania.
Recognize and debunk Springdale apartments for rent and apartments for rent in Springdale.
Identify and locate vacation rentals Northumberland, Northumberland Pennsylvania rental properties, and home rentals in Northumberland.
We procreated and set up our website, FRBO.com to be statuesque, charming, and delightful.
Distinguish and debunk holiday rentals Chicora and Chicora United States rental home.
Romantics, habitants, and itinerants who are wishing to explore, espy, and move or simply espy information can use this site, For Rent By Owner (FRBO.com).
Find, move, and ascertain vacation rentals in Crawford, vacation rental in Crawford Pennsylvania, and for rent by owner homes in Crawford Pennsylvania.
Recognize, glimpse, and dig up Centre Pennsylvania vacation homes, vacation homes for rent by owner in Centre Pennsylvania, and rental home Centre.
Catch and discover Westmoreland Pennsylvania homes for rent by owner and home rentals Westmoreland.
Debunk and espy rental homes in Spring Creek and Spring Creek United States rental apartment.
|
|
