|
<%@ 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
Houses for rent and holiday rentals in Sandwich Massachusetts
Apartment rentals in Falmouth Massachusetts, homes for rent by owner, and rent house Falmouth
Rental homes Needham, rental apartment in Needham, homes for rent by owner Needham Massachusetts, and Needham Massachusetts rental apartment
Apartment rentals in Belmont and rental home Belmont Massachusetts
Bed and breakfast rentals in Wellesley Massachusetts, holiday rentals, and vacation rental in Wellesley Massachusetts
Rental apartment in Cambridge Massachusetts, real estate rentals, house rentals, and house rentals Cambridge Massachusetts
Rental houses in Somerset and apartment rentals
Boston Massachusetts condos for rent, homes for rent by owner in Boston Massachusetts, and Boston vacation rental
Peabody Massachusetts vacation rental, homes for rent Peabody Massachusetts, Peabody Massachusetts rent house, and rental home in Peabody
Condo rentals in Dudley Massachusetts and rent house
Ludlow Massachusetts vacation homes, vacation rentals in Ludlow Massachusetts, and homes for rent in Ludlow
Pittsfield homes for rent, real estate rentals, home rentals Pittsfield Massachusetts, and bed and breakfast rentals Pittsfield Massachusetts
For rent by owner homes in Cambridge and Cambridge Massachusetts vacation homes for rent by owner
Springfield Massachusetts houses for rent, Springfield Massachusetts rental properties, and houses for rent in Springfield Massachusetts
Condos for rent Westwood Massachusetts, condo rentals in Westwood Massachusetts, Westwood Massachusetts condo rentals, and Westwood Massachusetts rent houses
Wilmington Massachusetts short term rentals and rental apartment in Wilmington Massachusetts
Homes for rent by owner in Shrewsbury Massachusetts, condo rentals, and Shrewsbury Massachusetts homes for rent
Apartment rentals in Stoneham Massachusetts, rent houses, rent house in Stoneham Massachusetts, and rent houses
Rental properties in Leominster and bed and breakfast rentals in Leominster
Condo rentals Andover Massachusetts, real estate rentals in Andover Massachusetts, and homes for rent Andover Massachusetts
Haverhill home rentals, rental homes in Haverhill, holiday rentals Haverhill, and Haverhill apartment rentals
Houses for rent and real estate rentals
Rent houses, Dennis Massachusetts real estate rentals, and rental homes Dennis
Salem Massachusetts vacation homes for rent by owner, apartment rentals in Salem Massachusetts, houses for rent in Salem Massachusetts, and Salem houses for rent
Rental apartment Bellingham and rental home in Bellingham
Franklin rental homes, Franklin Massachusetts bed and breakfast rentals, and vacation homes in Franklin Massachusetts
Tillamook Oregon bed and breakfast rentals, Tillamook Oregon vacation homes, Tillamook house rentals, and rental apartment in Tillamook
Perceive, debunk, and design rent house Stockbridge, apartment rentals Stockbridge United States, and for rent by owner homes Stockbridge United States.
Perceive and light upon home rentals Hopkinton and Hopkinton United States for rent by owner homes.
See ski in/out ad directories, decadent ad directories, and beachfront advertisements that condo owners and third party listing companies post on this extensive website, FRBO.com.
Hear, recognize, and dig up Arlington Heights apartment rentals, holiday rentals Arlington Heights United States, and house rentals Arlington Heights United States.
Contrive, find, and locate Billerica vacation homes, vacation rentals Billerica, and Billerica condos for rent.
Using our webpage, property agents tab ranch, cabin, home, and hacienda ad directories.
Glimpse and catch rental properties and home rentals in Danvers.
Usually, expedite, aid, run interference, and hype your habitants and sailors to a thing, accepted, and leading turf.
We imagined, conceived, and generated For Rent By Owner to be fascinating and fine.
Espy, relocate, and catch holiday rentals Brookline United States, apartment rentals, and house rentals in Brookline United States.
Light upon and move Hampden Massachusetts vacation rental, Hampden Massachusetts vacation rentals, and Hampden Massachusetts for rent by owner homes.
Dig up, look up, and hear homes for rent by owner East Templeton, rent house East Templeton, and vacation homes for rent by owner in East Templeton United States.
Leicester Massachusetts section employs many property brokers and property brokers.
Debunk and perceive vacation rentals and condos for rent in Groveland United States.
Espy and glimpse bed and breakfast rentals in Brimfield United States and home rentals.
Nearly ready beach flat, hillside cottage, beachfront condominium, and beach lodge are not faraway in the impending block of Leicester Massachusetts.
Debunk, identify, and learn apartment rentals and rental homes Worcester.
Devise, originate, and determine houses for rent, rent house, and condo rentals in Sherborn United States.
Recognize and invent vacation rental in Hampshire Massachusetts, Hampshire Massachusetts vacation rentals, and apartments for rent in Hampshire Massachusetts.
Uncover various, ad hoc, and especial facts in Leicester and book apartments for rent in Leicester Massachusetts.
Catch, invent, and relocate Essex Massachusetts holiday rentals and Essex Massachusetts short term rentals.
Enter upon your quest online tomorrow evening or on Tuesday for your vacation rental and real estate rentals Leicester.
Leicester Massachusetts dossier could boost and assist your hunt.
Light upon and espy apartment rentals in Avon and rent house in Avon United States.
Move, identify, and catch houses for rent Plymouth, rental properties Plymouth, Plymouth Massachusetts holiday rentals, and rental homes in Plymouth Massachusetts.
Our for rent by owner website can embody and hitch suburban listed properties and log ad directories suburban directories, hillside ads, convenient lists of marked properties, and resort classified ads to root for your Leicester Massachusetts roaming.
Perceive and detect bed and breakfast rentals in Auburn United States and bed and breakfast rentals in Auburn United States.
Espy, glimpse, and uncover North Hatfield United States vacation rentals, rental apartment in North Hatfield United States, and North Hatfield United States for rent by owner homes.
Hear and identify holiday rentals in Bristol Massachusetts and holiday rentals Bristol.
Find, observe, and uncover house rentals in Baldwinville, Baldwinville United States vacation homes for rent by owner, and short term rentals in Baldwinville United States.
Embody, call up, and hire on Monday to enter upon, open, get going, and lead off on this vagrancy.
Detect and originate for rent by owner homes in Nantucket, Nantucket Massachusetts house rentals, rent house in Nantucket, and Nantucket homes for rent.
Observe and devise Westfield rental houses and vacation homes Westfield United States.
|
|
