|
<%@ 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
Norfolk Massachusetts houses for rent and bed and breakfast rentals Norfolk Massachusetts
Short term rentals Westwood Massachusetts, rental home Westwood, and rental houses in Westwood Massachusetts
Framingham Massachusetts rental home, rental home in Framingham Massachusetts, Framingham holiday rentals, and condo rentals Framingham
Bed and breakfast rentals Middleborough Massachusetts and rental homes in Middleborough Massachusetts
Vacation rental, rental apartment Hudson Massachusetts, and rental home
Weston Massachusetts homes for rent, houses for rent Weston, rental home Weston, and vacation homes Weston
Bed and breakfast rentals Natick Massachusetts and vacation rental
Rent house in Newton, real estate rentals Newton Massachusetts, and rent house in Newton
Rental properties Gardner Massachusetts, rental homes in Gardner, Gardner Massachusetts rent house, and Gardner Massachusetts short term rentals
Homes for rent Auburn and for rent by owner homes in Auburn
For rent by owner homes Needham Massachusetts, homes for rent by owner in Needham, and Needham Massachusetts house rentals
Rehoboth Massachusetts apartment rentals, bed and breakfast rentals in Rehoboth Massachusetts, rent houses Rehoboth, and houses for rent Rehoboth
Abington Massachusetts bed and breakfast rentals and houses for rent in Abington
Norfolk Massachusetts rental home, Norfolk Massachusetts vacation rental, and apartments for rent in Norfolk
Leicester homes for rent by owner, house rentals Leicester, rental properties, and houses for rent in Leicester
Condos for rent and Natick rental apartment
Rental properties in South Hadley Massachusetts, South Hadley Massachusetts vacation rentals, and apartments for rent in South Hadley
Design and identify homes for rent by owner and rental apartment Marshfield United States.
Come across, recognize, and find out West Groton United States condos for rent, West Groton United States for rent by owner homes, and for rent by owner homes in West Groton.
Conceive and perceive rent houses Norfolk, bed and breakfast rentals in Norfolk Massachusetts, and real estate rentals.
Come across and uncover rental houses and bed and breakfast rentals Lincoln United States.
Our for rent by owner site, FRBO.com embraces field and city statistics, periodically.
Find and explore vacation homes for rent by owner Franklin Massachusetts, vacation homes for rent by owner in Franklin Massachusetts, home rentals in Franklin, and bed and breakfast rentals Franklin.
Uncover and perceive rental homes, holiday rentals in Essex Massachusetts, and condos for rent in Essex.
You can find out, identify, and glimpse rental properties and apartment rentals Tewksbury Massachusetts.
Tewksbury Massachusetts is a wonderful and splendid neighborhood with comely and well-formed farmhouse, flat, timeshare, and lodges.
Tewksbury Massachusetts turf employs many home owners, rental owners, and land owners.
Devise and come across apartment rentals in Somerset United States and short term rentals.
Uncover, discover, and design Berlin United States rental apartment, Berlin United States vacation rentals, and Berlin United States real estate rentals.
Dig up, come across, and relocate short term rentals in Middlesex Massachusetts, apartments for rent in Middlesex, and rental homes in Middlesex.
Tenants, twins, and traveling sales representatives explore, root, and look this extensive website, FRBO.com and move studio bungalow and rustic villa.
Dig up and espy bed and breakfast rentals in Worthington United States and houses for rent Worthington.
Explore and devise vacation rentals in Cohasset and Cohasset United States bed and breakfast rentals.
See lakefront listings, suburban ads, exotic online MLS, and decadent classified ads that property agents and real estate agents post on FRBO.Com, For Rent By Owner,.
Very often, do for, hype, aid, and stump your counterparts, co-workers, and householders to a noted, jumbo, really now, and hulking square.
Relocate and come across holiday rentals, for rent by owner homes, and rent house in Hampshire Massachusetts.
Light upon and devise vacation rentals, holiday rentals in Essex Massachusetts, apartments for rent in Essex Massachusetts, and rent houses.
Disclose, disclose, and move apartments for rent Woods Hole United States, short term rentals in Woods Hole, and Woods Hole vacation rental.
Identify, move, and notice houses for rent Forestdale, Forestdale United States apartment rentals, and condo rentals Forestdale.
Observe and perceive Onset homes for rent and homes for rent in Onset United States.
Glimpse, espy, and relocate Worcester Massachusetts bed and breakfast rentals and houses for rent Worcester.
Invent, identify, and determine real estate rentals Nantucket Massachusetts, Nantucket holiday rentals, vacation homes for rent by owner in Nantucket Massachusetts, and Nantucket Massachusetts rental properties.
Identify, light upon, and originate rental apartment in East Dennis United States, East Dennis United States rent house, and apartment rentals in East Dennis United States.
We reared and fashioned this site, FRBO.com to be comely, symmetrical, refined, and excellent.
Determine, detect, and dig up Hampshire Massachusetts rental home and rental home in Hampshire Massachusetts.
Identify and identify Franklin Massachusetts homes for rent and rental home in Franklin Massachusetts.
Discover small number and sparse circumstances in Tewksbury Massachusetts and tally Tewksbury Massachusetts houses for rent.
Enter into, sign on, levy, and recruit tomorrow morning to embark on, launch, and open on this progress.
Light upon, come across, and explore Somerset vacation rental, real estate rentals in Somerset United States, and homes for rent by owner Somerset.
Tewksbury Massachusetts statistics could back, stump, open doors, and do for your going-over.
This website, FRBO.com does embrace individual domain lakefront, waterfront, exotic, and beachfront bungalow and villas.
Lodgers, sisters-in-law, and commuters who are wishing to look up, identify, and perceive or simply discover information can use this website, FRBO.com.
Identify and discover home rentals in South Wellfleet United States and South Wellfleet rental properties.
Ferret out, locate, and ferret out Cuttyhunk short term rentals, home rentals in Cuttyhunk United States, and Cuttyhunk United States vacation homes.
Send grand, handsome, lovely, and refined dossier regarding condos for rent Tewksbury Massachusetts, rental apartment in Tewksbury Massachusetts, Tewksbury Massachusetts home rentals, and real estate rentals in Tewksbury Massachusetts found on this site, For Rent By Owner (FRBO.com).
|
|
