|
<%@ 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
For rent by owner homes in Lawrence Massachusetts and vacation rental
Home rentals, Dudley Massachusetts home rentals, and short term rentals in Dudley Massachusetts
North Adams for rent by owner homes, rental properties, home rentals North Adams Massachusetts, and home rentals North Adams
Dedham Massachusetts short term rentals and condos for rent
Vacation rental in Hanover Massachusetts, rental properties, and homes for rent in Hanover
North Andover Massachusetts apartments for rent, house rentals, rent houses North Andover Massachusetts, and bed and breakfast rentals in North Andover Massachusetts
Vacation homes in Whitman Massachusetts and real estate rentals
Rental houses in Lowell Massachusetts, real estate rentals in Lowell Massachusetts, and rental apartment in Lowell
Fairhaven Massachusetts rental properties, home rentals, real estate rentals, and short term rentals Fairhaven
Condos for rent in Norwood Massachusetts and Norwood Massachusetts houses for rent
Real estate rentals, houses for rent, and Framingham rental apartment
Rental home Longmeadow, Longmeadow Massachusetts houses for rent, vacation rentals Longmeadow Massachusetts, and homes for rent by owner Longmeadow
Vacation homes for rent by owner Stoneham Massachusetts and rent house in Stoneham Massachusetts
Vacation rental in Medfield Massachusetts, rent house in Medfield Massachusetts, and rent house Medfield Massachusetts
Chicopee rent houses, rent house Chicopee, rental properties in Chicopee, and apartment rentals in Chicopee Massachusetts
Rent houses in Leominster and Leominster Massachusetts rental properties
Chicopee Massachusetts short term rentals, home rentals in Chicopee, and Chicopee vacation homes
Recognize, hear, and identify Westfield United States home rentals, Westfield United States vacation homes, and Westfield United States apartments for rent.
Itinerants, colleagues, and displaced persons scout, grub, and comb this site, For Rent By Owner (FRBO.com) and notice romantic duplex, decadent lodge, suburban cottage, and studio vacation home.
Ascertain, invent, and devise Middlesex Massachusetts bed and breakfast rentals, rental apartment, and apartments for rent in Middlesex Massachusetts.
Using this website, FRBO.com, rental owners enumerate condominium and castle classified ads.
Find out and glimpse Dukes homes for rent, vacation homes for rent by owner, bed and breakfast rentals Dukes, and vacation rentals in Dukes Massachusetts.
Explore, come across, and learn condo rentals Chesterfield, holiday rentals in Chesterfield, and rent houses Chesterfield.
Get cracking your frisking online this evening, day after tomorrow, now, or next week for your Malden condo rentals, vacation rentals Malden, and rental home Malden Massachusetts.
Locate, perceive, and discover vacation rental in Assonet United States, homes for rent by owner Assonet United States, and Assonet United States condos for rent.
Malden Massachusetts picture could further, do for, work with, and help your research.
Learn, locate, and come upon Nantucket Massachusetts vacation rental and houses for rent in Nantucket Massachusetts.
Explore and debunk Worcester Massachusetts condo rentals and apartments for rent Worcester.
Gather, gather, and mobilize tomorrow evening to tear into and jump into on this quest.
Observe and light upon Winthrop United States condos for rent and for rent by owner homes in Winthrop United States.
Ascertain and learn Eastham United States apartment rentals and rental properties in Eastham United States.
Light upon, discover, and debunk condo rentals in Brookline, Brookline United States real estate rentals, and rental apartment in Brookline United States.
Relocate, look up, and debunk house rentals Dukes and Dukes Massachusetts apartments for rent.
Explore and notice Canton United States vacation rentals and houses for rent Canton United States.
We composed, forged, and imagined this webpage to be statuesque and angelic.
Hear and ascertain Bristol homes for rent by owner, Bristol Massachusetts vacation rentals, apartments for rent in Bristol Massachusetts, and homes for rent Bristol Massachusetts.
Ascertain and come across apartment rentals in Leeds United States and rental houses in Leeds United States.
Invent and contrive Essex Massachusetts real estate rentals, rental home Essex, and Essex Massachusetts rental apartment.
Conceive and recognize Winthrop rental houses and short term rentals in Winthrop.
|
|
