|
<%@ 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
Rental homes Westborough and Westborough bed and breakfast rentals
Apartment rentals Wakefield, rental home Wakefield Massachusetts, and rental apartment in Wakefield Massachusetts
Rental homes, vacation homes Canton, Canton Massachusetts for rent by owner homes, and short term rentals in Canton Massachusetts
Vacation homes for rent by owner in Gardner Massachusetts and Gardner condos for rent
Rental home in Tyngsborough Massachusetts, rental houses Tyngsborough, and Tyngsborough Massachusetts home rentals
Vacation rentals Leominster, Leominster Massachusetts condo rentals, short term rentals in Leominster, and Leominster Massachusetts homes for rent by owner
Vacation homes for rent by owner Hanover Massachusetts and for rent by owner homes in Hanover Massachusetts
Short term rentals in Reading Massachusetts, vacation homes for rent by owner, and Reading Massachusetts short term rentals
Vacation homes in Millbury, Millbury Massachusetts rental apartment, Millbury Massachusetts condos for rent, and Millbury condos for rent
Rental properties Shrewsbury and houses for rent Shrewsbury Massachusetts
Rent house, home rentals Cambridge, and Cambridge homes for rent by owner
Vacation homes in Chelmsford, rental homes in Chelmsford Massachusetts, Chelmsford Massachusetts rental houses, and short term rentals in Chelmsford Massachusetts
Burlington rental homes and Burlington Massachusetts short term rentals
Brookline Massachusetts condo rentals, Brookline Massachusetts vacation rentals, and home rentals in Brookline
Holiday rentals in Auburn, rental properties Auburn, Auburn Massachusetts homes for rent by owner, and Auburn Massachusetts rental properties
Short term rentals and rental home in Carver Massachusetts
Apartment rentals in Swansea Massachusetts, holiday rentals, and homes for rent in Swansea Massachusetts
Brewster real estate rentals, condos for rent in Brewster, for rent by owner homes in Brewster Massachusetts, and condos for rent in Brewster Massachusetts
Bed and breakfast rentals in Rockland and homes for rent by owner Rockland
Homes for rent by owner, house rentals North Adams, and apartments for rent
Springfield vacation rental, Springfield Massachusetts vacation homes for rent by owner, short term rentals Springfield, and rental apartment Springfield
Rental houses in Westford Massachusetts and Westford Massachusetts vacation rentals
Dedham vacation homes, Dedham Massachusetts rental homes, and Dedham rental properties
Using our for rent by owner website, property owners manifest ranch, bungalow, farmhouse, and duplex lists of marked properties.
Devise and come across Hatfield rental homes and condo rentals in Hatfield.
Uncover, learn, and disclose apartments for rent Essex Massachusetts, real estate rentals in Essex Massachusetts, rent houses in Essex Massachusetts, and rent houses in Essex Massachusetts.
You can ferret out and design vacation rentals in Quincy Massachusetts, rental properties in Quincy, and Quincy Massachusetts condos for rent.
Conceive and identify rental houses Plymouth, vacation rental Plymouth, and short term rentals Plymouth.
Observe and notice the county and proximate Quincy Massachusetts zone.
Quincy property agents, property managers, agents, and town home owners list house rentals Quincy, Quincy condo rentals, apartment rentals in Quincy, and Quincy Massachusetts homes for rent by owner.
The Quincy Massachusetts secluded advertisements, beachfront lists of marked properties, city lists of marked properties, and log lists of marked properties for these stretch can be mapped.
Determine, disclose, and distinguish Rochdale United States rental houses, rental houses in Rochdale United States, and condo rentals in Rochdale United States.
Glimpse, come upon, and detect vacation homes in Middlesex Massachusetts, Middlesex Massachusetts vacation rentals, and rental homes in Middlesex Massachusetts.
Empty beachfront houseboat, beach cabin, and beachfront farmhouse are abutting in the convenient section of Quincy.
Look up and come upon homes for rent Brookline Village and Brookline Village United States for rent by owner homes.
Find out, come upon, and contrive rental properties Bristol, short term rentals in Bristol, and Bristol Massachusetts home rentals.
Observe, discern, and contrive Franklin rental home, homes for rent by owner, and houses for rent Franklin Massachusetts.
Quincy Massachusetts is a pulchritudinous and delicate precinct with radiant, resplendent, stunning, and delicate timeshare, house, and farmhouses.
This website, FRBO.com can mobilize, list, and enter convenient classified ads, mountain indexes, and romantic online MLS exotic classified advertisements, lakeside advertisements, log listed properties, and exotic classified ads to cooperate your Quincy Massachusetts quest.
Detect, hear, and catch rent house Bristol, rental apartment in Bristol Massachusetts, Bristol rent houses, and Bristol Massachusetts rental apartment.
Move and disclose rental homes East Boston United States and houses for rent in East Boston United States.
Discern, dig up, and recognize holiday rentals Dunstable United States, home rentals in Dunstable United States, and homes for rent Dunstable United States.
Ferret out and look up apartment rentals in Bristol Massachusetts, condos for rent, and rental homes Bristol Massachusetts.
Espy and detect rental homes in Norfolk and Norfolk rental houses.
Identify, explore, and look up Southwick United States holiday rentals, Southwick United States vacation rentals, and rent house in Southwick United States.
|
|
