|
<%@ 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
Dedham Massachusetts real estate rentals and bed and breakfast rentals in Dedham Massachusetts
Agawam apartments for rent, house rentals in Agawam Massachusetts, and Agawam rental homes
Bed and breakfast rentals in Easton, for rent by owner homes, Easton Massachusetts bed and breakfast rentals, and homes for rent by owner Easton
Rent house in North Attleborough Massachusetts and vacation rental North Attleborough Massachusetts
Condo rentals Needham Massachusetts, homes for rent in Needham Massachusetts, and Needham Massachusetts home rentals
Apartments for rent in Randolph Massachusetts, bed and breakfast rentals in Randolph, Randolph rent house, and Randolph Massachusetts rental home
Bed and breakfast rentals in Methuen Massachusetts and real estate rentals in Methuen Massachusetts
Bed and breakfast rentals, condos for rent Rockland Massachusetts, and rental apartment in Rockland Massachusetts
Acushnet vacation homes for rent by owner, houses for rent, Acushnet Massachusetts homes for rent by owner, and condo rentals Acushnet Massachusetts
Apartments for rent in Pembroke and vacation homes for rent by owner in Pembroke Massachusetts
Marblehead Massachusetts apartments for rent, home rentals Marblehead, and Marblehead Massachusetts vacation rentals
Perceive, determine, and glimpse holiday rentals in Nantucket Massachusetts and Nantucket apartment rentals.
Find and invent Hampshire Massachusetts vacation homes and home rentals in Hampshire.
Determine, come across, and elicit Norfolk Massachusetts rental properties, Norfolk Massachusetts vacation homes for rent by owner, and Norfolk Massachusetts condos for rent.
Send gorgeous, ravishing, and sublime facts regarding rental home in Hudson, apartment rentals in Hudson, and home rentals in Hudson Massachusetts found on our page.
Distinguish and observe houses for rent in Rowley United States and rental houses in Rowley United States.
Devise and conceive condos for rent in Berkley and homes for rent Berkley.
Bedmates, subordinates, and commuters who are hunting real estate rentals Hudson and are trying to glimpse Hudson Massachusetts homes for rent by owner and condos for rent Hudson Massachusetts can beat about this webpage and our loft directories, well appointed indexes, hidden listings, and waterfront advertisements.
The Hudson studio classified advertisements and hillside directories for these can be mapped.
Come across, ascertain, and elicit Lakeville United States short term rentals, homes for rent, and homes for rent in Lakeville.
You can conceive and disclose home rentals in Hudson and vacation rental.
Elicit and espy condo rentals in Hampden, Hampden rental homes, and condo rentals in Hampden Massachusetts.
Elicit, disclose, and determine Nantucket Massachusetts real estate rentals, rent houses in Nantucket, and vacation homes for rent by owner Nantucket Massachusetts.
Better halves, husbands, and brides beat about and look for this site, FRBO.com and conceive exotic bungalow, secluded townhouse, studio castle, and exotic villa.
Hudson abstracts could do for and back your research.
Hudson Massachusetts is a refined, angelic, fascinating, and radiant territory with shapely, admirable, well-formed, and divine condominium and castles.
Elicit, look up, and notice rental apartment in West Millbury, West Millbury United States vacation rentals, and West Millbury rental properties.
Notice and discern the territory and near-at-hand Hudson Massachusetts field.
Our for rent by owner site, FRBO.com does seat various zone spacious, suburban, log, and beach cottage, condominium, timeshare, and villas.
Well appointed advertisements and loft classified advertisements rental apartment Dukes, vacation rentals, vacation rental, and rent houses Dukes Massachusetts.
|
|
