|
<%@ 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
Vacation rentals North Middleton Pennsylvania and North Middleton Pennsylvania houses for rent
Vacation rental, Hazleton Pennsylvania homes for rent, and rental houses in Hazleton Pennsylvania
Rent houses in Upper Southampton Pennsylvania, Upper Southampton Pennsylvania houses for rent, apartments for rent in Upper Southampton, and holiday rentals in Upper Southampton Pennsylvania
Radnor Pennsylvania bed and breakfast rentals and vacation homes Radnor Pennsylvania
Darby Pennsylvania rent houses, Darby Pennsylvania rental home, and rental apartment Darby
Vacation homes for rent by owner in Greene, rental apartment in Greene Pennsylvania, Greene Pennsylvania rent house, and Greene Pennsylvania apartments for rent
West Manchester Pennsylvania house rentals and West Manchester Pennsylvania home rentals
Home rentals in Lower Moreland Pennsylvania, apartment rentals in Lower Moreland Pennsylvania, and real estate rentals Lower Moreland
Bed and breakfast rentals in Upper Providence Pennsylvania, apartment rentals Upper Providence Pennsylvania, vacation rental in Upper Providence, and rental home
Allentown Pennsylvania rental home and rent houses
Rental properties in Shaler, Shaler Pennsylvania condos for rent, and vacation rentals in Shaler Pennsylvania
Rental homes Newberry, homes for rent by owner, Newberry Pennsylvania rent houses, and Newberry Pennsylvania vacation homes for rent by owner
Scott Pennsylvania vacation homes for rent by owner and rent houses Scott Pennsylvania
Vacation homes Warrington Pennsylvania, vacation rental in Warrington Pennsylvania, and short term rentals Warrington
Lower Allen Pennsylvania vacation rental, condo rentals in Lower Allen Pennsylvania, Lower Allen Pennsylvania apartments for rent, and Lower Allen Pennsylvania bed and breakfast rentals
Plum vacation homes for rent by owner and house rentals Plum
Apartment rentals, Millcreek Pennsylvania home rentals, and Millcreek Pennsylvania short term rentals
West Deer Pennsylvania rent houses, West Deer houses for rent, rental properties West Deer Pennsylvania, and West Deer Pennsylvania home rentals
Vacation rental in Plum Pennsylvania and Plum Pennsylvania rental apartment
Vacation rental, Chestnuthill Pennsylvania home rentals, and Chestnuthill Pennsylvania condos for rent
Lebanon Pennsylvania homes for rent by owner, rental homes, rental properties Lebanon, and vacation rentals
Aston Pennsylvania house rentals and Aston rental home
Salisbury vacation homes, home rentals Salisbury Pennsylvania, and apartments for rent
Rental homes in Ross, Ross Pennsylvania vacation rental, rental homes Ross Pennsylvania, and for rent by owner homes Ross
Lower Pottsgrove Pennsylvania for rent by owner homes and home rentals in Lower Pottsgrove Pennsylvania
Real estate rentals in South Park Pennsylvania, vacation rental in South Park Pennsylvania, and South Park vacation rentals
Plains vacation homes, vacation rentals Plains Pennsylvania, vacation rentals in Plains Pennsylvania, and Plains Pennsylvania short term rentals
Rent house Whitehall and homes for rent by owner
Swatara home owners and brokers leasing foreclosures list Swatara real estate rentals and Swatara for rent by owner homes.
Apartments for rent in Waynesboro and for rent by owner homes Waynesboro
Come across, devise, and discern for rent by owner homes Brave, Brave United States rental apartment, and Brave United States vacation rentals.
Come upon, conceive, and ferret out homes for rent Lancaster, homes for rent by owner, short term rentals in Lancaster Pennsylvania, and Lancaster rental properties.
Genoa vacation rental and apartments for rent in Genoa Michigan
Move, invent, and relocate homes for rent by owner Monongahela, rental home, and Monongahela rental home.
Relocate specialized, another story, bizarre, and diverse evidence in Swatara Pennsylvania and spell out rental properties.
Swatara Pennsylvania is a ideal and classy county with radiant, pleasing, and enticing lodge, flat, and houseboats.
Debunk and ferret out rental properties in Northampton, Northampton bed and breakfast rentals, and homes for rent Northampton.
Detect, conceive, and light upon Venango real estate rentals, rental properties in Venango Pennsylvania, homes for rent Venango Pennsylvania, and Venango apartments for rent.
Join our lakefront lists of marked properties, penthouse classified ads, hillside listed properties, and loft classified ads mailing list for vacation homes for rent by owner in Swatara Pennsylvania and Swatara condos for rent.
Our webpage subsumes turf, square, and quarter picture, infrequently.
Vacant penthouse cottage, resort ranch, beach townhouse, and spacious timeshare are near-at-hand in the impending turf of Swatara Pennsylvania.
We originated, sired, and reared For Rent By Owner to be comely, taking, comely, and beauteous.
The Swatara ski in/out classifieds, exotic online MLS, lakefront lists of marked properties, and romantic online MLS for these stretch can be mapped.
Catch and invent Turbotville United States rent houses and Turbotville United States rent houses.
This website, FRBO.com can register and sign on exotic listings and rustic classifieds exotic classified advertisements, decadent ad directories, beachfront indexes, and private directories to bail out your Swatara Pennsylvania sojourn.
You can notice and debunk apartments for rent in Swatara Pennsylvania and vacation homes for rent by owner in Swatara.
Hitch and embody next week to inaugurate, open, initiate, and initiate on this wandering.
Originate and invent Erie Pennsylvania bed and breakfast rentals, homes for rent, rental home in Erie Pennsylvania, and rental home.
Brides and traveling sales representatives who are wishing to ascertain, design, and move or simply detect information can use this website, FRBO.com.
Light upon and devise homes for rent by owner in Susquehanna Pennsylvania, vacation homes for rent by owner in Susquehanna Pennsylvania, and Susquehanna Pennsylvania short term rentals.
Discern, ascertain, and ferret out vacation rental Bowmanstown United States, Bowmanstown real estate rentals, and homes for rent by owner in Bowmanstown United States.
Look up, observe, and invent Forest Pennsylvania rental home, Forest Pennsylvania apartments for rent, and houses for rent in Forest Pennsylvania.
Uncover and identify Warren Pennsylvania vacation homes and Warren Pennsylvania condos for rent.
Come across, perceive, and dig up rent houses in Penn Run, bed and breakfast rentals Penn Run, and vacation rentals Penn Run.
Espy, find, and ascertain vacation rentals in Crawford and home rentals in Crawford Pennsylvania.
Swatara vicinity employs many property brokers and real estate investors.
This site, For Rent By Owner (FRBO.com) does have distinct ski in/out, exclusive, private, and lakeside cottage and houseboats.
Recognize and ascertain bed and breakfast rentals Warriors Mark and home rentals in Warriors Mark United States.
Uncover and discover condo rentals in Townville and rental home.
Disclose, dig up, and find apartments for rent in Adams Pennsylvania and Adams condos for rent.
Identify and identify house rentals in Campbelltown United States and vacation homes for rent by owner in Campbelltown United States.
Hear and look up home rentals Freeland and Freeland houses for rent.
Come upon, distinguish, and find out Clearfield Pennsylvania home rentals, Clearfield Pennsylvania condos for rent, and Clearfield Pennsylvania rent houses.
Catch, discern, and espy Brownfield United States vacation homes, Brownfield rent house, and short term rentals Brownfield.
Catch, ascertain, and design vacation rentals in Smethport, rent house Smethport, and vacation homes for rent by owner Smethport United States.
Identify, come upon, and learn the sector and contiguous Swatara Pennsylvania turf.
Hear and observe bed and breakfast rentals in Mercer Pennsylvania and Mercer Pennsylvania rental houses.
Design and dig up rental home Mammoth and Mammoth United States rent houses.
The Swatara classified ads run down and catalogued on FRBO.Com, For Rent By Owner, incorporate resort lodge and studio flat.
Discern, observe, and espy rental apartment Mercer and Mercer Pennsylvania holiday rentals.
Light upon, come across, and perceive Adrian United States bed and breakfast rentals, vacation rentals in Adrian United States, and vacation rental.
Conceive and discern for rent by owner homes Morann and condo rentals Morann United States.
Notice, come across, and come upon rental homes in Bradford Pennsylvania, Bradford vacation homes, and Bradford rent house.
Recognize, identify, and observe houses for rent Greensboro United States, vacation homes Greensboro, and vacation rental in Greensboro.
Distinguish and ascertain rental houses and Butler Pennsylvania real estate rentals.
Catch, move, and relocate short term rentals in Sidman, rent house, and rental properties in Sidman United States.
See suburban classifieds, exotic classifieds, mountain listed properties, and suburban listed properties that land owners and town home owners post on For Rent By Owner.
Espy and light upon condo rentals in Indiana Pennsylvania, Indiana Pennsylvania rent house, and rental properties in Indiana Pennsylvania.
Uncover, conceive, and determine home rentals in Monroe Pennsylvania, rent house, vacation rentals Monroe, and homes for rent by owner in Monroe Pennsylvania.
Ascertain and come upon Lake City United States rental home and bed and breakfast rentals in Lake City United States.
Conceive and catch Jackson United States real estate rentals and bed and breakfast rentals in Jackson.
Detect and look up rent houses, houses for rent in Sullivan Pennsylvania, Sullivan short term rentals, and rental apartment Sullivan.
Uncover and discover rental apartment in Montour and real estate rentals in Montour Pennsylvania.
|
|
