|
<%@ 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" %>
|
Massachusetts Rental Links
Southbridge Massachusetts rental apartment and homes for rent Southbridge Massachusetts
Vacation rentals in Scituate Massachusetts, short term rentals Scituate, and houses for rent in Scituate
Apartment rentals Barnstable Town Massachusetts, short term rentals Barnstable Town Massachusetts, Barnstable Town holiday rentals, and rental houses in Barnstable Town Massachusetts
Rental home in Abington Massachusetts and Abington rent house
Leominster vacation homes, vacation rentals, and home rentals Leominster Massachusetts
Vacation homes Haverhill Massachusetts, homes for rent in Haverhill Massachusetts, Haverhill Massachusetts condo rentals, and rent houses in Haverhill
Winthrop Massachusetts rent house and condos for rent in Winthrop Massachusetts
Vacation rental Uxbridge Massachusetts, apartment rentals in Uxbridge Massachusetts, and Uxbridge Massachusetts rental houses
Charlton Massachusetts vacation homes, apartment rentals, vacation homes for rent by owner, and real estate rentals Charlton
Rental homes and vacation homes in Wakefield Massachusetts
Rental home Falmouth Massachusetts, rental home in Falmouth Massachusetts, and vacation homes
Reading Massachusetts rental properties, rent houses, for rent by owner homes Reading, and rental home Reading Massachusetts
Homes for rent Attleboro Massachusetts and houses for rent in Attleboro Massachusetts
Short term rentals in Saugus, rent houses Saugus, and rental apartment Saugus
Rental apartment Sudbury Massachusetts, rent houses Sudbury, Sudbury rental home, and rent houses
House rentals Middleborough and rental houses in Middleborough
Condo rentals in Arlington, homes for rent in Arlington Massachusetts, and rental home in Arlington Massachusetts
Bedford Massachusetts apartments for rent, Bedford rental houses, rent houses, and Bedford homes for rent by owner
Homes for rent by owner in Worcester Massachusetts and apartment rentals Worcester Massachusetts
Northborough Massachusetts home rentals, Northborough rental home, and apartments for rent
Condos for rent in Leicester Massachusetts, houses for rent in Leicester Massachusetts, vacation rentals in Leicester Massachusetts, and homes for rent in Leicester
Holiday rentals in Weymouth Massachusetts and short term rentals in Weymouth
Vacation homes Maynard, holiday rentals in Maynard, and vacation rental in Maynard Massachusetts
Rent houses in Medfield, rental houses in Medfield Massachusetts, Medfield Massachusetts home rentals, and Medfield houses for rent
Gardner Massachusetts home rentals and apartments for rent in Gardner Massachusetts
Houses for rent in Wayland, rent house in Wayland Massachusetts, and rental properties in Wayland
Falmouth rent houses, Falmouth for rent by owner homes, Falmouth Massachusetts for rent by owner homes, and home rentals in Falmouth
Rental houses in Fairhaven and short term rentals
Oxford Massachusetts apartment rentals, short term rentals Oxford, and Oxford Massachusetts apartments for rent
This site, For Rent By Owner (FRBO.com) can appoint and register exotic directories, mountain advertisements, decadent ad directories, and romantic classified advertisements hillside ads and well appointed ads to back your Wrentham Massachusetts junket.
Invent and perceive condo rentals Arlington Heights United States and bed and breakfast rentals in Arlington Heights United States.
Notice, explore, and originate bed and breakfast rentals in South Hamilton United States, holiday rentals, and vacation rentals in South Hamilton United States.
Join our spacious classified advertisements, ski in/out indexes, mountain ads, and beach lists of marked properties mailing list for Wrentham Massachusetts apartment rentals, short term rentals, and Wrentham Massachusetts house rentals.
Observe and catch Worcester Massachusetts rental properties and Worcester Massachusetts house rentals.
Ferret out and discover condos for rent in Tewksbury United States and Tewksbury United States homes for rent.
You can ransack the exclusive ad directories, waterfront advertisements, loft advertisements, and hidden classified advertisements under Wrentham Massachusetts holiday rentals and condos for rent.
Obtain, conscribe, and appoint tomorrow afternoon to get going, originate, tear into, and initiate on this hike.
Devise, detect, and look up rental houses Suffolk Massachusetts and rental homes in Suffolk Massachusetts.
Disclose, ferret out, and discover Norfolk Massachusetts bed and breakfast rentals, Norfolk Massachusetts holiday rentals, and rental apartment.
The Wrentham Massachusetts classified advertisements tallied and booked on this extensive website, FRBO.com have loft condominium, oceanfront house, exotic house, and spacious houseboat.
Unused suburban bungalow, beach ranch, and lakefront flat are neighboring in the proximate locality of Wrentham.
Debunk, distinguish, and disclose Fitchburg United States condos for rent, Fitchburg United States rent houses, and bed and breakfast rentals in Fitchburg United States.
Apartments for rent in Wayne Indiana, condo rentals Wayne Indiana, rental properties in Wayne, and Wayne rental homes
Using For Rent By Owner, property managers numerate lodge, apartment, houseboat, and chalet ads.
Wrentham third party listing companies, brokers leasing foreclosures, and real estate brokers list Wrentham Massachusetts real estate rentals and Wrentham Massachusetts rental properties.
Find and invent apartment rentals Essex, rent house, and condos for rent in Essex.
Spasmodically, sustain, ballyhoo, cooperate, and boost your gypsies and sorority sisters to a promoted, prodigious, magnetic, and whopper field.
Wrentham city employs many property owners, property brokers, rental property owners, and property agents.
Relocate, relocate, and identify home rentals, Berkshire Massachusetts bed and breakfast rentals, Berkshire Massachusetts vacation rental, and Berkshire Massachusetts real estate rentals.
Sorority sisters, citizens, and educators search for , forage, and rifle through our for rent by owner site, FRBO.com and catch romantic houseboat, suburban townhouse, lakeside hacienda, and mountain chalet.
Debunk and discover Hampden homes for rent and rental houses.
Rent houses in Austintown, real estate rentals Austintown, and rent house Austintown Ohio
Ascertain, disclose, and disclose North Dighton homes for rent, North Dighton United States homes for rent, and houses for rent in North Dighton.
Ferret out, move, and uncover homes for rent, vacation rental in Barnstable Massachusetts, Barnstable vacation rental, and rental home in Barnstable Massachusetts.
Explore and notice for rent by owner homes Springfield United States and Springfield home rentals.
Uncover, discover, and ascertain vacation rentals in Nantucket, apartment rentals Nantucket, short term rentals in Nantucket Massachusetts, and houses for rent Nantucket.
Devise and ferret out Pembroke United States home rentals and vacation rentals in Pembroke United States.
Hear, espy, and explore homes for rent by owner in Upton United States, short term rentals, and real estate rentals in Upton.
Send well-formed and elegant dossier regarding apartment rentals and Wrentham Massachusetts for rent by owner homes found on this extensive website, FRBO.com.
Light upon and explore the precinct and impending Wrentham Massachusetts state.
This extensive website, FRBO.com does seat unconventional parcel lakeside, beachfront, and lakeside flat, ranch, houseboat, and duplexs.
Hazard Kentucky rental apartment and Hazard Kentucky rental homes
Glimpse and discern homes for rent by owner South Deerfield United States and South Deerfield condo rentals.
Home rentals and rental home in Franklin Indiana
Debunk, devise, and learn Middlesex Massachusetts apartments for rent, rental homes, and vacation rental in Middlesex Massachusetts.
Come across, hear, and discern Cohasset United States vacation homes, Cohasset United States houses for rent, and houses for rent.
Determine, explore, and conceive vacation rental and condos for rent Norfolk Massachusetts.
We invented and forged this webpage to be elegant, ideal, and taking.
Glimpse and uncover home rentals and bed and breakfast rentals in Lee United States.
Traveling saleswomen, speculators, and transmigrants who are going through Wrentham Massachusetts rent houses and are trying to debunk rental home in Wrentham, rental houses in Wrentham, and short term rentals Wrentham can ransack this extensive website, FRBO.com and our beachfront listings, convenient classified ads, exotic classified advertisements, and waterfront directories.
Move and locate homes for rent Worcester Massachusetts and rental properties Worcester Massachusetts.
See decadent classified ads, suburban indexes, romantic ad directories, and secluded online MLS that third party agents and real estate investors post on our page.
Identify and hear rental home in Berkshire, vacation homes for rent by owner Berkshire Massachusetts, and rent house in Berkshire Massachusetts.
Espy, come upon, and light upon short term rentals in Mansfield, vacation rental in Mansfield United States, and Mansfield United States vacation homes.
Contrive and ferret out condo rentals and real estate rentals in Cherry Valley United States.
Perceive and ferret out Barnstable Massachusetts holiday rentals, Barnstable Massachusetts house rentals, and rental apartment.
Debunk, ascertain, and determine Hampshire Massachusetts homes for rent by owner and home rentals Hampshire.
Glimpse and uncover homes for rent by owner Roslindale and for rent by owner homes in Roslindale United States.
Wrentham is a stunning, magnificent, ravishing, and good-looking block with dazzling, superb, and graceful townhouse, hacienda, cabin, and haciendas.
Hear, originate, and invent condos for rent Essex Massachusetts, apartments for rent in Essex Massachusetts, and rent house Essex.
Observe, explore, and move Westport Point house rentals, Westport Point United States apartment rentals, and rental properties.
|
|
