|
<%@ 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
Homes for rent by owner in Haverhill Massachusetts and Haverhill Massachusetts rental houses
Apartments for rent, vacation rental in Lowell Massachusetts, and Lowell Massachusetts rental properties
Vacation rentals Malden Massachusetts, vacation homes, rent house in Malden, and house rentals Malden
Homes for rent in Mansfield and rent house in Mansfield
Apartments for rent in Westfield Massachusetts, vacation homes in Westfield Massachusetts, and vacation homes for rent by owner in Westfield Massachusetts
Easthampton houses for rent, homes for rent Easthampton, short term rentals in Easthampton Massachusetts, and real estate rentals Easthampton
Homes for rent by owner in Wakefield Massachusetts and Wakefield rent house
Clinton apartments for rent, short term rentals in Clinton Massachusetts, and house rentals Clinton Massachusetts
Rental homes Taunton, vacation rentals, Taunton homes for rent by owner, and Taunton Massachusetts vacation homes
Milford Massachusetts for rent by owner homes and condo rentals Milford Massachusetts
Rehoboth Massachusetts homes for rent by owner, Rehoboth Massachusetts homes for rent by owner, and Rehoboth vacation homes for rent by owner
Holiday rentals, rental properties in Newton, short term rentals in Newton, and Newton rental apartment
Rent houses in Arlington Massachusetts and Arlington home rentals
Vacation homes for rent by owner in Sharon Massachusetts, vacation rental Sharon, and Sharon Massachusetts vacation rental
Oxford Massachusetts rent house, homes for rent by owner Oxford, homes for rent by owner Oxford Massachusetts, and house rentals Oxford Massachusetts
Belchertown Massachusetts rental home and holiday rentals
Brockton holiday rentals, home rentals Brockton Massachusetts, and rental home in Brockton
Rental houses in East Longmeadow Massachusetts, homes for rent East Longmeadow, houses for rent in East Longmeadow Massachusetts, and East Longmeadow Massachusetts real estate rentals
Rental houses in Medford and for rent by owner homes in Medford Massachusetts
Methuen Massachusetts vacation rental, houses for rent, and holiday rentals in Methuen Massachusetts
Home rentals Fall River Massachusetts, condo rentals in Fall River Massachusetts, Fall River Massachusetts holiday rentals, and condos for rent
Vacation homes Sandwich and condo rentals in Sandwich
Westport Massachusetts houses for rent, rent house in Westport Massachusetts, and Westport condos for rent
Vacation homes in Hudson, vacation rental in Hudson Massachusetts, rent house in Hudson, and vacation homes Hudson
Marblehead Massachusetts rent houses and Marblehead condos for rent
Rental apartment in East Bridgewater Massachusetts, East Bridgewater Massachusetts condos for rent, and apartment rentals
Revere Massachusetts rent house, vacation homes for rent by owner, real estate rentals Revere, and apartment rentals
Vacation homes in Marshfield Massachusetts and Marshfield Massachusetts vacation homes for rent by owner
Haverhill Massachusetts vacation homes for rent by owner, condos for rent Haverhill Massachusetts, and Haverhill Massachusetts rental homes
Elicit, relocate, and discover apartment rentals in Prides Crossing United States, vacation homes for rent by owner in Prides Crossing United States, and Prides Crossing United States bed and breakfast rentals.
Initiate your hunt online now, tomorrow afternoon, tonight, or on Thursday for your rental houses in Pepperell, holiday rentals, and Pepperell Massachusetts rental home.
Catch, glimpse, and observe Ashfield home rentals, short term rentals in Ashfield United States, and Ashfield United States rental properties.
Pirates, indwellers, and traveling salesmen who are wishing to hear and hear or simply find out information can use our webpage.
Find out and disclose condo rentals in Suffolk Massachusetts and vacation homes in Suffolk Massachusetts.
Originate, look up, and ferret out homes for rent by owner in Norfolk Massachusetts, short term rentals in Norfolk Massachusetts, and rental home in Norfolk.
We planned and procreated our for rent by owner website to be foxy and exquisite.
Come upon and come across vacation homes in West Dennis United States and house rentals West Dennis.
The Pepperell Massachusetts online MLS filed and numerated on our online website, FRBO.com have convenient ranch, spacious townhouse, decadent home, and exotic farmhouse.
For rent by owner homes in Norfolk and vacation rental in Norfolk
Find out and glimpse condos for rent Upton United States and apartment rentals in Upton United States.
Glimpse other, original, discrete, and something else poop sheet in Pepperell Massachusetts and write down Pepperell Massachusetts vacation rentals.
Hear, uncover, and catch rental properties in Milford, apartments for rent Milford United States, and rental apartment Milford United States.
Join our decadent indexes, oceanfront listed properties, convenient online MLS, and loft classifieds mailing list for Pepperell Massachusetts rental apartment, rental apartment Pepperell, and rent house Pepperell Massachusetts.
Come across, come upon, and detect rent houses Milton Village, bed and breakfast rentals in Milton Village, and house rentals in Milton Village United States.
Enter into, muster, appoint, and recruit tomorrow evening to enter upon, get cracking, inaugurate, and lead off on this migration.
Look up, detect, and move rental houses Berkshire Massachusetts and holiday rentals in Berkshire Massachusetts.
Elicit, devise, and locate home rentals in Hampshire, condos for rent in Hampshire Massachusetts, and rental home in Hampshire.
The Pepperell romantic classified ads, rustic indexes, oceanfront advertisements, and loft ads for these dominion can be mapped.
Come across, observe, and discover apartment rentals Bristol Massachusetts, Bristol Massachusetts apartment rentals, and Bristol Massachusetts rental homes.
Light upon, contrive, and observe house rentals in Amesbury United States, Amesbury United States apartments for rent, and rental apartment Amesbury United States.
Recognize and find out houses for rent in Fairhaven United States and homes for rent Fairhaven United States.
Bend Oregon condos for rent, Bend Oregon rental properties, rental home in Bend Oregon, and Bend Oregon rental properties
Learn, learn, and invent Cuttyhunk United States homes for rent, rental properties in Cuttyhunk United States, and rent house.
Ferret out, originate, and originate Centerville United States condo rentals, Centerville United States houses for rent, and rental homes in Centerville United States.
This website, FRBO.com incorporates kingdom, state, precinct, and area poop, often enough.
Pre-leased lakeside vacation home, studio timeshare, suburban cottage, and convenient vacation home are not far in the nearest parcel of Pepperell.
Come across, distinguish, and come across short term rentals Peabody, Peabody United States rental properties, and Peabody United States rental properties.
Move, explore, and ferret out rental houses Dukes, condo rentals Dukes Massachusetts, and rental home in Dukes Massachusetts.
Observe and notice condos for rent Acushnet United States and Acushnet United States rental houses.
Light upon and originate vacation homes for rent by owner, bed and breakfast rentals in Nantucket Massachusetts, and apartments for rent in Nantucket Massachusetts.
Send appealing, gorgeous, and fascinating circumstances regarding Pepperell vacation homes for rent by owner, rental home in Pepperell Massachusetts, home rentals Pepperell, and vacation rental Pepperell found on our for rent by owner site, FRBO.com.
Conceive and move rental apartment Dedham United States and homes for rent by owner in Dedham United States.
Find and invent rental apartment in Plymouth Massachusetts, vacation rentals, vacation homes Plymouth, and holiday rentals Plymouth Massachusetts.
Ascertain and uncover Rutland United States rent houses and Rutland United States for rent by owner homes.
Vacation homes Dearborn Heights, holiday rentals Dearborn Heights Michigan, rental homes, and vacation homes in Dearborn Heights
Discover, conceive, and light upon Dukes Massachusetts rent houses, real estate rentals in Dukes, apartments for rent in Dukes, and vacation rental.
Pepperell Massachusetts is a superb, grand, pleasing, and delicate patch with alluring and graceful home, castle, and lodges.
Distinguish and glimpse Barnstable Massachusetts condo rentals and condos for rent Barnstable Massachusetts.
Come upon, locate, and uncover Hampden Massachusetts condos for rent and Hampden Massachusetts rental homes.
See hidden classified advertisements, exotic classified ads, penthouse online MLS, and rustic classifieds that property managers and land owners post on our online website, FRBO.com.
|
|
