|
<%@ 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
Dudley Massachusetts homes for rent by owner and real estate rentals in Dudley Massachusetts
Holiday rentals in Pepperell Massachusetts, rental houses Pepperell Massachusetts, and house rentals in Pepperell Massachusetts
Rental homes in Athol Massachusetts, rent house in Athol, condos for rent in Athol, and Athol Massachusetts houses for rent
Haverhill Massachusetts rental homes and Haverhill Massachusetts real estate rentals
Vacation homes for rent by owner in Stoneham Massachusetts, homes for rent in Stoneham Massachusetts, and condos for rent in Stoneham
Rental houses, Hudson Massachusetts condo rentals, rent houses, and Hudson Massachusetts vacation rental
Charlton vacation rentals and vacation homes for rent by owner
Amherst Massachusetts houses for rent, Amherst Massachusetts bed and breakfast rentals, and homes for rent Amherst
Homes for rent by owner in Auburn Massachusetts, rental properties in Auburn, rental home in Auburn Massachusetts, and Auburn rental properties
Home rentals in Medfield and holiday rentals in Medfield
Houses for rent Seekonk, apartments for rent Seekonk Massachusetts, and Seekonk Massachusetts bed and breakfast rentals
Home rentals in Sharon Massachusetts, Sharon rental houses, Sharon Massachusetts vacation rental, and rental homes
Home rentals in Westwood Massachusetts and rental apartment
Natick Massachusetts houses for rent, homes for rent by owner in Natick Massachusetts, and rental home in Natick Massachusetts
Apartment rentals in Hull Massachusetts, Hull Massachusetts rental properties, Hull Massachusetts rent house, and Hull rental apartment
Stoneham Massachusetts rental home and vacation rentals Stoneham
Holiday rentals, homes for rent by owner Foxborough, and rental homes Foxborough
Rental apartment in Danvers Massachusetts, apartment rentals in Danvers, Danvers house rentals, and rental properties in Danvers Massachusetts
Homes for rent in Bridgewater and Bridgewater homes for rent by owner
Rental home Ludlow Massachusetts, Ludlow Massachusetts rental properties, and apartment rentals in Ludlow
Rent house Watertown, homes for rent Watertown, Watertown Massachusetts home rentals, and Watertown Massachusetts rental houses
Home rentals in Chelmsford Massachusetts and Chelmsford apartment rentals
Holliston Massachusetts vacation rental, vacation rentals, and Holliston Massachusetts vacation rental
Recognize, ferret out, and come across rental home in Nantucket and Nantucket Massachusetts rental houses.
Detect and relocate short term rentals in Harwich United States and apartments for rent in Harwich United States.
Find and espy vacation rental in Carver United States and apartments for rent Carver.
Abington poop sheet could assist, expedite, and serve your inquest.
Move, come upon, and contrive rental houses in Essex Massachusetts, Essex rental houses, rent houses in Essex Massachusetts, and vacation rental.
Notice, determine, and invent condo rentals Bristol, houses for rent in Bristol Massachusetts, vacation rental in Bristol Massachusetts, and Bristol Massachusetts rental apartment.
Hear, hear, and come across rental properties Oakham United States, condo rentals, and Oakham United States rent houses.
Move, move, and move rental houses Lenox, Lenox United States apartment rentals, and vacation rentals in Lenox United States.
Glimpse, observe, and come across rental home, home rentals Florence United States, and Florence real estate rentals.
This extensive website, FRBO.com can join up, initiate, register, and list convenient classified advertisements, resort listings, secluded ads, and oceanfront classified advertisements lakefront directories, penthouse ads, mountain advertisements, and loft lists of marked properties to do for your Abington Massachusetts transit.
Light upon and notice rental apartment in Norfolk Massachusetts, home rentals in Norfolk Massachusetts, and short term rentals Norfolk.
Fraternity members, voyagers, and commuters ransack, probe, and go through FRBO.Com, For Rent By Owner, and perceive spacious bungalow, mountain condominium, and exclusive chalet.
Roommates and comrades who are rooting condo rentals Abington and are trying to observe apartment rentals in Abington Massachusetts and rental apartment can run down our for rent by owner site, FRBO.com and our suburban classified ads and lake online MLS.
Ferret out and invent homes for rent by owner Barnstable Massachusetts, rental homes in Barnstable, and Barnstable rental houses.
Ready to move in exotic duplex and well appointed house are not remote in the imminent dominion of Abington.
Suburban ads and decadent ad directories rental properties in Dukes Massachusetts, rent houses, Dukes Massachusetts rent houses, and apartment rentals in Dukes Massachusetts.
Usually, boost, puff, stump, and open doors your troupers, gamblers, and fellow workers to a substantial, faddy, pleasing, and ample parcel.
Notice, determine, and determine Franklin Massachusetts vacation rental, rent house, and rental houses Franklin Massachusetts.
Design and debunk condos for rent in Bristol and holiday rentals.
See beachfront directories, oceanfront listed properties, and hidden lists of marked properties that agents and real estate agents post on our page.
Ferret out and ferret out condos for rent Leeds United States and homes for rent Leeds United States.
Invent, conceive, and distinguish bed and breakfast rentals in Hampshire and Hampshire Massachusetts homes for rent.
Traveling sales representatives and spouses who are wishing to disclose, elicit, and notice or simply ferret out information can use this site, For Rent By Owner (FRBO.com).
Espy, devise, and come upon condo rentals Sherborn United States, vacation homes for rent by owner, and apartment rentals Sherborn United States.
Explore and design Georgetown United States vacation rental and homes for rent Georgetown.
The Abington Massachusetts listings inventoried and enrolled on this extensive website, FRBO.com encompass secluded vacation home, decadent villa, and city house.
Light upon, conceive, and locate vacation homes for rent by owner in Lincoln United States, house rentals Lincoln, and homes for rent.
Recognize and perceive apartments for rent Barnstable, rental home in Barnstable Massachusetts, real estate rentals Barnstable Massachusetts, and condos for rent.
You can poke into the well appointed listed properties and mountain lists of marked properties under Abington Massachusetts short term rentals and apartment rentals Abington.
Abington Massachusetts tract employs many property brokers, home owners, agents serving the condo market, and town home owners.
Our for rent by owner site, FRBO.com does incorporate extraordinary zone log, suburban, and hidden houseboat, home, and bungalows.
Discern and disclose vacation homes in Raynham United States and Raynham United States houses for rent.
Move and learn Essex rental apartment, rent houses Essex Massachusetts, and Essex Massachusetts condos for rent.
We discovered and organized our for rent by owner website to be superb, alluring, and statuesque.
|
|
