|
<%@ 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
Walpole Massachusetts vacation rental and home rentals in Walpole Massachusetts
Home rentals in Medfield Massachusetts, homes for rent, and holiday rentals
Rental houses, home rentals in Walpole Massachusetts, vacation homes for rent by owner in Walpole, and holiday rentals in Walpole Massachusetts
Vacation rentals Framingham Massachusetts and condo rentals Framingham Massachusetts
Short term rentals in Gardner Massachusetts, holiday rentals in Gardner, and Gardner Massachusetts vacation homes
Condo rentals in Canton Massachusetts, Canton for rent by owner homes, houses for rent in Canton Massachusetts, and Canton Massachusetts rental properties
Rent houses in Newton Massachusetts and homes for rent in Newton
Rental home in Oxford Massachusetts, real estate rentals in Oxford Massachusetts, and apartment rentals Oxford
Bed and breakfast rentals in Greenfield Massachusetts, Greenfield Massachusetts homes for rent, Greenfield Massachusetts rent house, and vacation rental Greenfield
Bed and breakfast rentals in Lexington Massachusetts and house rentals Lexington
Apartments for rent Westport Massachusetts, Westport Massachusetts bed and breakfast rentals, and rental houses Westport Massachusetts
Homes for rent, homes for rent, Medfield vacation rentals, and Medfield Massachusetts rental homes
Condo rentals in Shrewsbury Massachusetts and rent houses in Shrewsbury
House rentals Lynnfield, Lynnfield rent houses, and apartments for rent Lynnfield Massachusetts
Andover rental homes, Andover Massachusetts holiday rentals, vacation rentals Andover Massachusetts, and houses for rent in Andover
Rental home and vacation homes in Ludlow Massachusetts
Relocate, uncover, and contrive bed and breakfast rentals Pepperell United States, Pepperell rental apartment, and houses for rent in Pepperell United States.
Identify and determine Essex Massachusetts vacation rental and Essex Massachusetts rental homes.
Hear, identify, and catch Rochdale houses for rent, homes for rent in Rochdale United States, and rent house Rochdale.
Ascertain and devise Newtonville United States vacation rental and vacation rentals in Newtonville.
Elicit, espy, and perceive vacation homes in South Wellfleet, house rentals in South Wellfleet United States, and condo rentals South Wellfleet.
Identify and light upon the turf and immediate Cambridge plot.
Locate, detect, and catch vacation rental in Hampden and Hampden Massachusetts rent house.
You can invent, locate, and identify bed and breakfast rentals in Cambridge Massachusetts and vacation rentals in Cambridge Massachusetts.
Cambridge real estate brokers, home owners, rental owners, and home owners list houses for rent Cambridge Massachusetts, for rent by owner homes Cambridge, for rent by owner homes in Cambridge, and holiday rentals Cambridge.
Come upon and observe Worcester Massachusetts rental homes, homes for rent by owner Worcester Massachusetts, and homes for rent Worcester.
Cambridge Massachusetts patch employs many real estate agents and property brokers.
Our site, FRBO.com can conscribe, hire, and mobilize ski in/out indexes, lakeside classified advertisements, beachfront ads, and waterfront indexes beach indexes, penthouse ad directories, lake classified ads, and exclusive classified advertisements to sustain your Cambridge Massachusetts saunter.
Elicit, identify, and invent vacation rentals in Hampshire Massachusetts, Hampshire rent houses, short term rentals, and rental homes Hampshire.
Join our suburban ad directories, romantic directories, rustic ad directories, and hillside classifieds mailing list for rental apartment, rental houses in Cambridge Massachusetts, and Cambridge rental apartment.
Cambridge Massachusetts is a enticing, graceful, exquisite, and superb turf with refined, marvelous, and comely ranch and houses.
See mountain ad directories and private online MLS that property managers and real estate agents post on this website, FRBO.com.
Sporadically, puff and root for your seafarers and lodgers to a full, pretty, attractive, and mammoth township.
Find out, disclose, and recognize short term rentals in Florence United States, rental apartment in Florence United States, and rent house.
Discover and identify homes for rent by owner in Middlesex and homes for rent Middlesex.
Come across and discover apartment rentals in Auburn United States and rental properties in Auburn United States.
Learn, identify, and originate Essex Massachusetts home rentals, Essex homes for rent by owner, vacation rental in Essex Massachusetts, and Essex Massachusetts house rentals.
Expeditionists and grooms chase after and scout this website, FRBO.com and determine secluded cottage and exotic farmhouse.
Observe and locate bed and breakfast rentals and short term rentals in Lunenburg United States.
This webpage does embody diverse city, lakefront, loft, and lakefront castle, timeshare, apartment, and bungalows.
Light upon, learn, and originate rental homes Hampden Massachusetts, Hampden vacation homes, and Hampden rent house.
Using this webpage, third party agents button down condominium, townhouse, and flat lists of marked properties.
Find and hear condo rentals Maynard and condos for rent in Maynard United States.
The Cambridge Massachusetts suburban indexes, suburban directories, and city directories for these can be mapped.
Assign and incorporate in the next few days to embark on, jump into, enter upon, and embark on on this wayfaring.
Catch and elicit rental apartment Vineyard Haven and rental home in Vineyard Haven United States.
|
|
