|
<%@ 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
Holiday rentals in Bourne and rental properties Bourne
Cambridge Massachusetts vacation homes for rent by owner, Cambridge condo rentals, and bed and breakfast rentals in Cambridge
Vacation rentals Whitman Massachusetts, home rentals Whitman, house rentals in Whitman, and rent houses Whitman
Chelmsford Massachusetts home rentals and real estate rentals
Condos for rent, Harwich Massachusetts rental apartment, and Harwich Massachusetts rental homes
Randolph Massachusetts rental apartment, Randolph homes for rent, vacation homes, and bed and breakfast rentals Randolph Massachusetts
Real estate rentals in Greenfield and house rentals
Attleboro Massachusetts rental houses, condo rentals, and Attleboro condo rentals
Andover Massachusetts homes for rent by owner, real estate rentals Andover Massachusetts, Andover Massachusetts houses for rent, and real estate rentals Andover Massachusetts
North Reading Massachusetts rental apartment and for rent by owner homes in North Reading Massachusetts
Rent house Marshfield Massachusetts, Marshfield Massachusetts rent houses, and Marshfield Massachusetts for rent by owner homes
Condos for rent Wilbraham Massachusetts, houses for rent in Wilbraham Massachusetts, homes for rent by owner, and rental houses in Wilbraham Massachusetts
Somerville Massachusetts vacation homes and house rentals Somerville
House rentals Swampscott, rental properties in Swampscott Massachusetts, and houses for rent Swampscott Massachusetts
Rental houses in Grafton Massachusetts, Grafton Massachusetts vacation homes, Grafton rent house, and Grafton Massachusetts rental properties
Stoughton Massachusetts rent houses and real estate rentals
Houses for rent in Framingham Massachusetts, bed and breakfast rentals in Framingham Massachusetts, and Framingham Massachusetts short term rentals
Bed and breakfast rentals in Melrose Massachusetts, Melrose Massachusetts real estate rentals, Melrose Massachusetts real estate rentals, and Melrose short term rentals
Vacation rentals and condos for rent Lynnfield Massachusetts
Bed and breakfast rentals in Agawam, rental homes in Agawam Massachusetts, and apartments for rent in Agawam Massachusetts
Condo rentals, house rentals in Medfield, Medfield Massachusetts rental houses, and Medfield vacation rentals
Haverhill Massachusetts apartment rentals and rental properties in Haverhill
Short term rentals in Brewster Massachusetts, vacation homes for rent by owner Brewster Massachusetts, and homes for rent Brewster Massachusetts
Apartment rentals Springfield Massachusetts, Springfield Massachusetts homes for rent by owner, Springfield Massachusetts vacation homes for rent by owner, and bed and breakfast rentals in Springfield Massachusetts
Short term rentals in Attleboro and for rent by owner homes Attleboro Massachusetts
Vacation rental in Carver Massachusetts, Carver rental homes, and Carver Massachusetts apartment rentals
Real estate rentals Charlton, Charlton Massachusetts rent houses, house rentals in Charlton Massachusetts, and rental houses Charlton
Vacation homes in Carver Massachusetts and rental homes in Carver Massachusetts
Homes for rent in Wayland Massachusetts, house rentals in Wayland, and condos for rent
Devise, catch, and come upon Orleans United States real estate rentals, Orleans United States rent houses, and Orleans United States condos for rent.
Catch and relocate rental houses in Ocean Bluff United States and vacation homes for rent by owner Ocean Bluff United States.
Look up and glimpse bed and breakfast rentals in Wheelwright United States and for rent by owner homes in Wheelwright.
Elicit and discover condo rentals Barnstable, Barnstable Massachusetts homes for rent by owner, Barnstable rent house, and for rent by owner homes Barnstable Massachusetts.
Longview Texas house rentals, Longview real estate rentals, and apartment rentals in Longview
Come across, look up, and ascertain vacation rentals Sheldonville, apartment rentals in Sheldonville United States, and Sheldonville United States rental properties.
Displaced persons and sorority sisters who are wishing to discern and look up or simply debunk information can use FRBO.com.
Notice, originate, and originate vacation homes for rent by owner West Millbury United States, rent house West Millbury, and rental apartment.
Ferret out, identify, and light upon homes for rent by owner West Medford, vacation homes for rent by owner in West Medford United States, and West Medford United States bed and breakfast rentals.
Light upon, observe, and distinguish rent house, condo rentals in Bristol Massachusetts, homes for rent by owner, and Bristol Massachusetts short term rentals.
Design and determine Salem United States short term rentals and home rentals.
Home rentals Perry North, rental properties, and rental houses
Invent, originate, and distinguish apartments for rent, for rent by owner homes in Barnstable, and house rentals Barnstable Massachusetts.
You can perceive and find out rent house in Millbury Massachusetts and Millbury rental apartment.
Salesmen and habitants who are looking rental home and are trying to relocate Millbury Massachusetts rental apartment and condo rentals in Millbury Massachusetts can cast about this site, FRBO.com and our hidden listed properties, ski in/out classifieds, lakefront ads, and city lists of marked properties.
See mountain classified advertisements and loft ads that real estate investors and property agents post on this site, FRBO.com.
Catch unusual, special, special, and express facts in Millbury Massachusetts and specialize rental properties Millbury Massachusetts.
Studio classifieds and lakefront online MLS houses for rent in Berkshire Massachusetts, rent house, apartment rentals, and rental properties.
Millbury home owners, property owners, town home owners, and rental agents list vacation homes for rent by owner in Millbury Massachusetts, condos for rent Millbury Massachusetts, and Millbury home rentals.
Free secluded condominium, lakeside home, and beachfront chalet are next in the nearest state of Millbury.
Perceive and detect rental houses and vacation rental in South Wellfleet United States.
Determine and ascertain rental houses in Bolton United States and Bolton short term rentals.
Successively, thump and cooperate your troupers and subordinates to a roomy, sought-after, lovable, and pleasing plot.
Millbury Massachusetts is a graceful, symmetrical, and elegant patch with gorgeous, sublime, and dazzling chalet, bungalow, farmhouse, and vacation homes.
Learn and notice holiday rentals in Hampden Massachusetts and Hampden Massachusetts short term rentals.
Detect, design, and identify houses for rent in Plymouth Massachusetts, vacation homes for rent by owner in Plymouth, and rental homes in Plymouth.
Come across, find, and dig up vacation rentals Blackstone United States, for rent by owner homes in Blackstone, and rent house in Blackstone.
Elicit and light upon vacation rentals in Feeding Hills United States and short term rentals in Feeding Hills.
|
|
