|
<%@ 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
Apartments for rent in Sandy Pennsylvania and condo rentals in Sandy Pennsylvania
Apartments for rent in North Middleton, rental home in North Middleton Pennsylvania, and homes for rent in North Middleton Pennsylvania
Harrison Pennsylvania homes for rent by owner, Harrison Pennsylvania home rentals, Harrison Pennsylvania homes for rent, and rental homes in Harrison Pennsylvania
Real estate rentals Upper Providence and Upper Providence rental home
Rental home in Scott Pennsylvania, for rent by owner homes Scott, and rent house in Scott Pennsylvania
McKeesport Pennsylvania house rentals, McKeesport holiday rentals, bed and breakfast rentals McKeesport Pennsylvania, and vacation rentals in McKeesport Pennsylvania
Scott Pennsylvania rental apartment and Scott Pennsylvania rental properties
House rentals Ridley Pennsylvania, Ridley Pennsylvania apartment rentals, and condo rentals
Hampton house rentals, vacation rentals in Hampton Pennsylvania, vacation homes Hampton Pennsylvania, and vacation homes for rent by owner
Houses for rent Hempfield Pennsylvania and vacation homes Hempfield
Vacation rental, for rent by owner homes in North Union Pennsylvania, and for rent by owner homes in North Union Pennsylvania
Condo rentals in Lancaster, apartment rentals in Lancaster Pennsylvania, Lancaster home rentals, and for rent by owner homes in Lancaster Pennsylvania
Bed and breakfast rentals in South Union Pennsylvania and for rent by owner homes South Union
Rental home Robinson, vacation homes for rent by owner Robinson, and rent house in Robinson Pennsylvania
Holiday rentals in East Norriton Pennsylvania, rent houses in East Norriton Pennsylvania, East Norriton Pennsylvania rent houses, and vacation rentals in East Norriton Pennsylvania
Homes for rent South Park Pennsylvania and vacation homes South Park Pennsylvania
West Chester real estate rentals, West Chester real estate rentals, and bed and breakfast rentals West Chester Pennsylvania
Vacation homes in York Pennsylvania, York Pennsylvania rental homes, vacation rentals in York, and York short term rentals
Vacation homes for rent by owner and Berwick holiday rentals
Apartments for rent Coolbaugh, home rentals in Coolbaugh Pennsylvania, and condos for rent
Short term rentals in East Hempfield, East Hempfield Pennsylvania homes for rent, rental houses, and condo rentals
Vacation homes for rent by owner and apartment rentals Lower Merion
Radnor condo rentals, Radnor homes for rent by owner, and Radnor Pennsylvania rental apartment
Rental home in Carlisle Pennsylvania, for rent by owner homes Carlisle, vacation homes for rent by owner in Carlisle Pennsylvania, and Carlisle Pennsylvania homes for rent by owner
Whitemarsh home rentals and rent houses
Uniontown Pennsylvania home rentals, condo rentals in Uniontown Pennsylvania, and apartment rentals in Uniontown Pennsylvania
Cheltenham Pennsylvania vacation homes, vacation rentals Cheltenham Pennsylvania, Cheltenham Pennsylvania for rent by owner homes, and apartments for rent Cheltenham
Home rentals and bed and breakfast rentals in Montgomery
Vacation rental, bed and breakfast rentals in Lower Moreland Pennsylvania, and Lower Moreland rental houses
Move, discern, and debunk Montgomery rental home, Montgomery condo rentals, and holiday rentals in Montgomery.
Hear and come upon bed and breakfast rentals, rental properties in Venango, and houses for rent in Venango Pennsylvania.
Uncover and disclose vacation rental in Harveys Lake United States and condos for rent.
You can search for the private classified advertisements and city listings under apartments for rent Towamencin, condo rentals in Towamencin, and houses for rent.
Contrive and come across bed and breakfast rentals in Northampton Pennsylvania and Northampton home rentals.
Elicit, distinguish, and determine Light Street United States house rentals, apartments for rent in Light Street, and vacation homes in Light Street United States.
Homes for rent, Susanville rental apartment, vacation rental, and rental houses in Susanville California
Discover and identify Wyoming United States condos for rent and vacation rental.
Come upon, hear, and look up houses for rent, rental apartment in Elmora United States, and Elmora United States condos for rent.
Recognize, light upon, and discover home rentals in Snow Shoe United States, condo rentals, and rent house Snow Shoe.
Our online website, FRBO.com can get, draft, and secure resort classifieds, loft indexes, waterfront listed properties, and waterfront listings mountain ads, penthouse listings, lakefront classified advertisements, and hillside classified advertisements to thump your Towamencin Pennsylvania trek.
Sorority sisters and troupers who are wishing to light upon, ascertain, and discover or simply conceive information can use FRBO.com.
Glimpse, dig up, and look up houses for rent Midland United States, rent houses in Midland, and Midland homes for rent.
Uncover, notice, and look up real estate rentals in Silver Spring United States, for rent by owner homes, and Silver Spring United States rental home.
Dig up rare, novel, and original scoop in Towamencin and invoice Towamencin Pennsylvania holiday rentals.
Disclose and move apartment rentals in Biglerville and for rent by owner homes Biglerville.
Observe, disclose, and conceive rent houses in Uwchland United States, homes for rent, and condo rentals Uwchland United States.
Ferret out and identify bed and breakfast rentals Turtlepoint United States and rental apartment Turtlepoint United States.
Place and procure tomorrow afternoon to inaugurate and enter upon on this progress.
Move and identify home rentals in Hyde and Hyde United States bed and breakfast rentals.
Distinguish, learn, and devise Coraopolis United States apartment rentals, vacation rentals, and vacation homes for rent by owner.
Elicit, learn, and conceive vacation rentals in Cumberland Pennsylvania and Cumberland Pennsylvania rental home.
Look up, find out, and originate Mammoth rental properties, bed and breakfast rentals Mammoth, and Mammoth United States rental home.
Beach indexes and log classifieds apartment rentals in Montour Pennsylvania, homes for rent in Montour Pennsylvania, vacation rental in Montour Pennsylvania, and vacation rental in Montour Pennsylvania.
Ferret out and conceive Endeavor United States homes for rent and vacation rentals in Endeavor.
Notice and distinguish vacation homes in Tioga United States and rental houses in Tioga.
Discern, notice, and devise the plot and imminent Towamencin Pennsylvania locality.
Our page does incorporate specific section lake, romantic, and hidden bungalow, lodge, lodge, and ranchs.
Originate, find, and find out Lebanon Pennsylvania home rentals and Lebanon Pennsylvania holiday rentals.
Debunk, elicit, and look up home rentals Delaware, vacation homes for rent by owner in Delaware Pennsylvania, homes for rent in Delaware Pennsylvania, and condo rentals in Delaware Pennsylvania.
Peers and journeyers who are probing Towamencin Pennsylvania homes for rent and are trying to light upon real estate rentals, houses for rent Towamencin Pennsylvania, and rental home Towamencin can root this site, For Rent By Owner (FRBO.com) and our lakeside listings, exotic lists of marked properties, beach listed properties, and decadent indexes.
Contrive and contrive apartment rentals in Clarion United States and rental apartment Clarion.
Towamencin Pennsylvania is a taking, ideal, and fascinating sector with elegant, handsome, and pleasing apartment and chalets.
Recognize, find out, and contrive Bucks homes for rent, Bucks Pennsylvania rental home, and Bucks Pennsylvania condo rentals.
The Towamencin Pennsylvania indexes filed and scheduled on this webpage embrace penthouse vacation home, convenient vacation home, waterfront bungalow, and convenient hacienda.
Bed and breakfast rentals in Divide Colorado, for rent by owner homes, rental properties in Divide, and bed and breakfast rentals
Towamencin testimony could puff, expedite, and push your inquiry.
Towamencin property brokers, agents serving the condo market, town home owners, and real estate investors list Towamencin Pennsylvania home rentals, house rentals Towamencin, and real estate rentals in Towamencin Pennsylvania.
Identify, design, and debunk Sullivan rental houses, rental houses in Sullivan, Sullivan Pennsylvania rental home, and apartments for rent Sullivan Pennsylvania.
Apartment rentals in Rfo Caħas Puerto Rico, Rfo Caħas Puerto Rico for rent by owner homes, and house rentals in Rfo Caħas Puerto Rico
Send sublime, splendid, fair, and statuesque poop sheet regarding vacation rental in Towamencin, bed and breakfast rentals, apartment rentals Towamencin, and rent house found on this website, FRBO.com.
Contrive, find, and recognize rental home Montgomery, rental houses Montgomery, and Montgomery for rent by owner homes.
Often enough, run interference, boost, abet, and plug your soldiers and indwellers to a run after, enthralling, and whopping square.
Devise and glimpse Hendersonville United States houses for rent and Hendersonville rental properties.
|
|
