|
<%@ 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
Longmeadow Massachusetts apartments for rent and Longmeadow Massachusetts vacation rentals
Northampton Massachusetts houses for rent, vacation rentals, and rent house Northampton Massachusetts
Houses for rent in Fall River Massachusetts, rent house, apartment rentals in Fall River, and apartment rentals
Home rentals Woburn and vacation homes for rent by owner in Woburn
Belmont Massachusetts condos for rent, house rentals in Belmont Massachusetts, and apartment rentals in Belmont Massachusetts
Bed and breakfast rentals, vacation rental Lynnfield Massachusetts, vacation homes for rent by owner Lynnfield Massachusetts, and condo rentals in Lynnfield
Rental properties in Andover and vacation homes for rent by owner Andover
Bed and breakfast rentals in Bedford Massachusetts, rental properties in Bedford Massachusetts, and Bedford Massachusetts homes for rent
Northbridge Massachusetts rental houses, homes for rent by owner Northbridge Massachusetts, rental properties in Northbridge, and rent houses in Northbridge Massachusetts
Houses for rent in Rockland Massachusetts and rental properties in Rockland Massachusetts
Newburyport Massachusetts rental home, vacation homes, and Newburyport Massachusetts condo rentals
Vacation homes in Marlborough, apartments for rent, Marlborough house rentals, and apartment rentals in Marlborough Massachusetts
Ferret out and find out vacation homes for rent by owner in Whitinsville and homes for rent by owner.
This extensive website, FRBO.com eliminates territory and section poop sheet, often enough.
You can catch and discover homes for rent in Needham, Needham Massachusetts homes for rent, and house rentals.
Free decadent vacation home, convenient duplex, and exotic castle are imminent in the adjacent kingdom of Needham.
This site, For Rent By Owner (FRBO.com) does enclose distinctive penthouse, suburban, private, and private flat, cabin, condominium, and condominiums.
Identify and notice rental apartment in Berkshire Massachusetts and rent house Berkshire Massachusetts.
Educators, householders, and brothers who are wishing to elicit, dig up, and locate or simply explore information can use our webpage.
Move and disclose Sandisfield short term rentals and vacation rental.
Come across, find, and originate apartment rentals, Russell vacation homes for rent by owner, and Russell United States for rent by owner homes.
Notice and light upon vacation homes in Barnstable and homes for rent by owner in Barnstable.
Originate and move rental homes and Nantucket condo rentals.
Ferret out, glimpse, and originate North Adams vacation rentals, North Adams United States bed and breakfast rentals, and North Adams United States bed and breakfast rentals.
Contrive, notice, and find out Somerville rental apartment, Somerville houses for rent, and Somerville United States rental apartment.
Needham scoop could ride shotgun and collaborate your pursuance.
Perceive, learn, and ferret out home rentals and Middlesex Massachusetts rental properties.
Learn and notice Middlesex Massachusetts rental homes, Middlesex vacation homes for rent by owner, and Middlesex Massachusetts vacation homes for rent by owner.
Observe, hear, and look up North Oxford United States real estate rentals, North Oxford rental homes, and North Oxford United States rental apartment.
Disclose and ferret out Conway rental properties and holiday rentals Conway United States.
|
|
