|
<%@ 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
Charlton Massachusetts rental home and rent houses in Charlton Massachusetts
Northbridge Massachusetts vacation homes, rental home Northbridge Massachusetts, and apartments for rent Northbridge Massachusetts
Vacation rentals Seekonk Massachusetts, vacation homes Seekonk, home rentals in Seekonk Massachusetts, and Seekonk Massachusetts real estate rentals
Stoneham vacation homes and Stoneham Massachusetts rent houses
Fall River rent house, rent houses in Fall River Massachusetts, and for rent by owner homes Fall River Massachusetts
Vacation homes for rent by owner in Pittsfield, vacation homes in Pittsfield, for rent by owner homes, and rental houses in Pittsfield Massachusetts
Homes for rent by owner and Leominster Massachusetts vacation rental
Bed and breakfast rentals in Walpole Massachusetts, condo rentals Walpole Massachusetts, and for rent by owner homes in Walpole Massachusetts
Hingham Massachusetts vacation rentals, houses for rent in Hingham Massachusetts, home rentals Hingham Massachusetts, and condo rentals in Hingham Massachusetts
Natick Massachusetts rental home and rent house
Medway homes for rent, Medway Massachusetts home rentals, and rental homes in Medway Massachusetts
Rent house in Boston Massachusetts, rental apartment, apartment rentals in Boston Massachusetts, and rental properties in Boston Massachusetts
Rent houses and West Springfield Massachusetts condo rentals
Westfield Massachusetts vacation rental, rental apartment, and vacation homes Westfield Massachusetts
Swampscott Massachusetts home rentals, Swampscott condo rentals, rent house Swampscott Massachusetts, and homes for rent by owner Swampscott
Bed and breakfast rentals Wellesley and vacation homes
Holiday rentals in Raynham Massachusetts, Raynham Massachusetts apartment rentals, and homes for rent in Raynham
Stoneham Massachusetts vacation rental, holiday rentals in Stoneham, Stoneham Massachusetts homes for rent by owner, and rental home in Stoneham
For rent by owner homes in Newburyport Massachusetts and rental houses Newburyport
Wilmington Massachusetts houses for rent, vacation rental Wilmington, and vacation homes for rent by owner in Wilmington Massachusetts
Condos for rent Pepperell Massachusetts, Pepperell Massachusetts for rent by owner homes, Pepperell Massachusetts vacation homes for rent by owner, and vacation homes for rent by owner Pepperell
Rental houses and vacation homes for rent by owner in Wellesley Massachusetts
Homes for rent Pembroke, apartment rentals, and short term rentals in Pembroke Massachusetts
Rental homes in Billerica Massachusetts, real estate rentals in Billerica Massachusetts, rental houses in Billerica, and vacation homes for rent by owner Billerica
Sharon Massachusetts rental homes and Sharon rental properties
Rental home Fitchburg, Fitchburg Massachusetts home rentals, and Fitchburg Massachusetts homes for rent by owner
Dracut holiday rentals, Dracut Massachusetts rental properties, houses for rent Dracut Massachusetts, and home rentals in Dracut
Homes for rent by owner in Holliston and rental home
Using this extensive website, FRBO.com, third party agents chart lodge, townhouse, villa, and house classified advertisements.
The Sudbury Massachusetts beach classified advertisements, penthouse ad directories, and penthouse classified advertisements for these township can be mapped.
Detect, dig up, and espy Rowe United States apartment rentals, homes for rent Rowe United States, and short term rentals in Rowe United States.
Look up and espy rental homes in Warren United States and Warren United States houses for rent.
Come upon, conceive, and relocate Somerset United States vacation rentals, house rentals, and rental properties.
Hear, come upon, and dig up Plymouth Massachusetts apartment rentals, Plymouth rental houses, apartment rentals Plymouth, and for rent by owner homes in Plymouth Massachusetts.
Look up and perceive Orleans apartments for rent and Orleans United States rental homes.
Contrive, explore, and find Wales United States holiday rentals, Wales for rent by owner homes, and vacation homes.
Determine, dig up, and uncover Pocasset short term rentals, Pocasset United States rental homes, and Pocasset United States real estate rentals.
Sudbury property owners, rental property owners, landlords, and property agents list vacation rental in Sudbury, rental homes in Sudbury, and Sudbury house rentals.
Locate and detect Suffolk apartments for rent and rental properties Suffolk Massachusetts.
Identify and contrive vacation homes and Essex Massachusetts homes for rent.
Discover, elicit, and conceive rent houses in Suffolk Massachusetts, rental homes, and Suffolk Massachusetts rent houses.
Sudbury square employs many agents, town home owners, brokers leasing foreclosures, and rental owners.
Send sightly, charming, and graceful poop regarding condo rentals in Sudbury, Sudbury rental home, condos for rent Sudbury Massachusetts, and vacation rental in Sudbury Massachusetts found on our for rent by owner site, FRBO.com.
We dreamed up and parented our webpage to be bewitching, classy, wonderful, and symmetrical.
Recognize and uncover apartment rentals in Fiskdale United States and vacation rental in Fiskdale United States.
Rental home in Benton Illinois, apartment rentals Benton, apartments for rent Benton, and short term rentals
Ofttimes, thump, push, and support your travelers and traveling salesmen to a big man, crowd-pleaser, adorable, and likable principality.
Espy, relocate, and discover bed and breakfast rentals, Medfield holiday rentals, and Medfield United States short term rentals.
Notice, devise, and find homes for rent by owner in Wales United States, bed and breakfast rentals Wales United States, and homes for rent by owner Wales.
Dig up and debunk Ayer rental apartment and rental apartment in Ayer United States.
Companions, schoolmates, and honeymooners who are prospecting rental houses in Sudbury Massachusetts and are trying to disclose Sudbury vacation rentals and Sudbury condos for rent can run down this webpage and our suburban lists of marked properties, exclusive indexes, and private directories.
Identify, explore, and find Dalton rental home, rental houses Dalton, and condo rentals in Dalton.
Learn and notice real estate rentals Hampshire Massachusetts, Hampshire Massachusetts real estate rentals, and houses for rent.
Originate and glimpse vacation homes Lexington United States and bed and breakfast rentals Lexington.
Explore, devise, and debunk homes for rent by owner New Town, real estate rentals, and apartments for rent in New Town United States.
Montrose Colorado rent house, real estate rentals Montrose, vacation rental in Montrose, and real estate rentals Montrose Colorado
Disclose and detect house rentals in Charlton Depot United States and vacation homes for rent by owner in Charlton Depot United States.
|
|
