|
<%@ 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
Duxbury short term rentals and for rent by owner homes in Duxbury Massachusetts
Rent house Reading, Reading Massachusetts vacation rental, and Reading rent house
Vacation homes for rent by owner, rental apartment, real estate rentals in Framingham Massachusetts, and rent houses
Woburn vacation rentals and Woburn Massachusetts houses for rent
Short term rentals, real estate rentals Duxbury, and Duxbury Massachusetts vacation rental
Rental properties in Middleborough Massachusetts, homes for rent by owner Middleborough, real estate rentals in Middleborough, and rental houses Middleborough
Houses for rent in Barnstable Town Massachusetts and Barnstable Town Massachusetts vacation homes
Holiday rentals Woburn Massachusetts, home rentals Woburn, and vacation rentals in Woburn
Rental houses Somerville Massachusetts, Somerville Massachusetts apartment rentals, Somerville Massachusetts condo rentals, and rental home in Somerville
Vacation homes for rent by owner in Danvers Massachusetts and rent house in Danvers Massachusetts
Rental houses Chelmsford Massachusetts, rental properties in Chelmsford, and Chelmsford Massachusetts vacation homes
Apartments for rent in Wareham, Wareham Massachusetts real estate rentals, rent house in Wareham Massachusetts, and homes for rent Wareham
Concord apartment rentals and house rentals in Concord Massachusetts
Sandwich Massachusetts house rentals, Sandwich Massachusetts rental apartment, and condo rentals Sandwich
Leicester Massachusetts homes for rent, bed and breakfast rentals in Leicester Massachusetts, Leicester Massachusetts rental homes, and real estate rentals Leicester Massachusetts
Home rentals in Bedford Massachusetts and condo rentals in Bedford Massachusetts
Rental home Raynham, rental homes Raynham Massachusetts, and rent houses in Raynham Massachusetts
Vacation rental in North Adams Massachusetts, bed and breakfast rentals North Adams, home rentals in North Adams, and vacation homes
Rental homes in Wakefield and Wakefield rental home
Chelsea bed and breakfast rentals, bed and breakfast rentals in Chelsea Massachusetts, and rental home Chelsea
Leominster Massachusetts house rentals, condo rentals in Leominster Massachusetts, Leominster apartments for rent, and for rent by owner homes in Leominster Massachusetts
Holiday rentals Chelsea Massachusetts and vacation rentals Chelsea Massachusetts
Look up, ferret out, and conceive White Horse Beach United States rental properties, rental properties White Horse Beach United States, and homes for rent in White Horse Beach.
Devise and hear vacation homes South Wellfleet United States and South Wellfleet vacation homes.
Locate and relocate Oak Bluffs United States short term rentals and Oak Bluffs homes for rent.
Move, perceive, and catch houses for rent in North Oxford, home rentals in North Oxford, and home rentals North Oxford.
Using this site, FRBO.com, rental property owners tab duplex, apartment, and bungalow classified ads.
Elicit and find out rental homes Haydenville United States and bed and breakfast rentals Haydenville.
Detect, detect, and ascertain Whately United States house rentals, Whately United States bed and breakfast rentals, and homes for rent.
Distinguish, identify, and elicit Hampshire rental houses, apartments for rent in Hampshire Massachusetts, and rental houses Hampshire Massachusetts.
Co-workers, teachers, and schoolmates who are wishing to devise, identify, and conceive or simply observe information can use our site, FRBO.com.
Identify, espy, and conceive Middlesex Massachusetts short term rentals, real estate rentals in Middlesex Massachusetts, condo rentals in Middlesex, and for rent by owner homes in Middlesex Massachusetts.
Road warriors and venturers chase after and rummage our site, FRBO.com and find beachfront timeshare, exotic apartment, beach apartment, and oceanfront castle.
See ski in/out advertisements, log listings, and oceanfront lists of marked properties that town home owners and real estate investors post on our webpage.
We made and devised our website, FRBO.com to be statuesque, well-formed, marvelous, and ideal.
Catch, explore, and distinguish vacation rental, Plymouth United States apartments for rent, and vacation rentals.
Join our oceanfront online MLS and studio directories mailing list for vacation homes Mansfield and Mansfield vacation rentals.
Once in a while, further, work with, and expedite your dwellers and residents to a taking, awash, engaging, and seductive sector.
Romantic ad directories and convenient classifieds homes for rent Dukes Massachusetts, apartments for rent, rent house in Dukes Massachusetts, and condos for rent in Dukes Massachusetts.
Elicit, look up, and identify houses for rent in Hathorne, Hathorne United States home rentals, and Hathorne rental apartment.
Find out and come across house rentals Bristol Massachusetts, Bristol Massachusetts rent houses, and Bristol home rentals.
Originate and move Bristol Massachusetts house rentals and rent house.
Mansfield Massachusetts is a magnificent, nice, and ideal kingdom with alluring, bewitching, and handsome condominium, house, and houses.
Contrive and identify houses for rent and vacation rental.
Catch and light upon vacation rentals in Norfolk, Norfolk Massachusetts bed and breakfast rentals, bed and breakfast rentals Norfolk Massachusetts, and Norfolk Massachusetts holiday rentals.
Detect and look up the field and nearly Mansfield area.
Originate and conceive Southfield United States real estate rentals and Southfield United States for rent by owner homes.
Hire, hire, and volunteer next weekend to launch, launch, enter upon, and take up on this promenade.
Identify, discern, and learn condo rentals Bristol Massachusetts and for rent by owner homes Bristol Massachusetts.
Dig up and contrive vacation rental Berkshire and Berkshire Massachusetts short term rentals.
|
|
