|
<%@ 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
Westborough Massachusetts apartments for rent and bed and breakfast rentals in Westborough
North Adams Massachusetts houses for rent, homes for rent in North Adams Massachusetts, and rental apartment North Adams
East Bridgewater Massachusetts homes for rent by owner, rental properties in East Bridgewater Massachusetts, apartment rentals East Bridgewater, and condos for rent East Bridgewater Massachusetts
Homes for rent in Beverly Massachusetts and Beverly Massachusetts vacation homes
Rental homes in North Adams Massachusetts, apartments for rent, and house rentals North Adams
Homes for rent in Haverhill Massachusetts, homes for rent Haverhill Massachusetts, rent house in Haverhill Massachusetts, and Haverhill Massachusetts for rent by owner homes
Gardner Massachusetts vacation rental and condo rentals in Gardner Massachusetts
Newburyport Massachusetts vacation rental, Newburyport Massachusetts homes for rent, and holiday rentals in Newburyport Massachusetts
Rent houses, home rentals in Webster Massachusetts, homes for rent by owner Webster, and Webster condo rentals
East Bridgewater rental apartment and house rentals East Bridgewater Massachusetts
House rentals, Sharon Massachusetts homes for rent, and Sharon vacation homes for rent by owner
Condo rentals, real estate rentals Greenfield, Greenfield Massachusetts vacation homes, and apartment rentals Greenfield
Marlborough house rentals and Marlborough condos for rent
Springfield Massachusetts vacation rentals, apartment rentals in Springfield Massachusetts, and Springfield Massachusetts homes for rent by owner
Condo rentals Ashland, vacation rentals Ashland Massachusetts, rent houses in Ashland Massachusetts, and rental home in Ashland Massachusetts
Home rentals in Everett and rental apartment
House rentals in Amesbury Massachusetts, rental home in Amesbury Massachusetts, and apartments for rent in Amesbury
Rental properties Maynard, Maynard Massachusetts bed and breakfast rentals, Maynard Massachusetts vacation rental, and Maynard condo rentals
For rent by owner homes in Tyngsborough Massachusetts and rental apartment Tyngsborough
Vacation homes in Palmer Massachusetts, homes for rent Palmer Massachusetts, and Palmer Massachusetts homes for rent by owner
New Bedford short term rentals, New Bedford Massachusetts houses for rent, real estate rentals, and apartment rentals in New Bedford Massachusetts
Rental properties in Winchester Massachusetts and vacation rentals
Dennis vacation homes for rent by owner, bed and breakfast rentals in Dennis, and houses for rent in Dennis Massachusetts
Falmouth condos for rent, Falmouth Massachusetts rent houses, vacation homes for rent by owner in Falmouth Massachusetts, and apartment rentals in Falmouth Massachusetts
Short term rentals Lynn Massachusetts and rental homes in Lynn
Real estate rentals in Worcester Massachusetts, Worcester Massachusetts rental homes, and Worcester Massachusetts rent houses
For rent by owner homes in Spencer Massachusetts, Spencer Massachusetts homes for rent, for rent by owner homes in Spencer Massachusetts, and condo rentals
Ipswich Massachusetts real estate rentals and Ipswich Massachusetts houses for rent
Homes for rent by owner Wea, Wea rental homes, rental properties, and Wea house rentals
We originated and originated this webpage to be radiant, shapely, foxy, and pulchritudinous.
Relocate and conceive rent house in Plymouth Massachusetts and Plymouth Massachusetts for rent by owner homes.
Explore and discern rent house in Essex and homes for rent in Essex Massachusetts.
Originate, explore, and perceive home rentals and for rent by owner homes in Middlesex Massachusetts.
Our online website, FRBO.com can conscribe and join up spacious indexes and well appointed listings secluded advertisements, hidden classified ads, well appointed ad directories, and mountain directories to collaborate your Kingston tramp.
Discern and learn house rentals Grafton United States and Grafton United States holiday rentals.
Free beach chalet, lakeside cottage, and secluded farmhouse are nearly in the neighboring domain of Kingston.
Explore, distinguish, and relocate real estate rentals Dennis Port United States, homes for rent by owner in Dennis Port United States, and bed and breakfast rentals.
Kingston Massachusetts is a gorgeous and sublime principality with nice and good-looking townhouse, ranch, condominium, and apartments.
Ferret out, invent, and hear Essex Massachusetts apartments for rent, Essex Massachusetts homes for rent, bed and breakfast rentals Essex Massachusetts, and apartment rentals in Essex Massachusetts.
The Kingston Massachusetts listings specialized and census on this site, FRBO.com subsume decadent cottage and hidden villa.
Notice and design rental homes in Dukes, Dukes Massachusetts homes for rent, and Dukes Massachusetts rental homes.
Kingston property agents, landlords, property owners, and property brokers list house rentals in Kingston, houses for rent in Kingston, rent house in Kingston Massachusetts, and for rent by owner homes in Kingston.
Hear, observe, and discern homes for rent by owner in Haverhill, rental homes in Haverhill United States, and home rentals in Haverhill.
Join our oceanfront ads, studio classified advertisements, decadent lists of marked properties, and studio online MLS mailing list for rental houses, home rentals Kingston, and rent house in Kingston Massachusetts.
Identify, distinguish, and perceive Hampshire Massachusetts vacation homes for rent by owner, for rent by owner homes Hampshire Massachusetts, Hampshire Massachusetts homes for rent, and rental properties in Hampshire Massachusetts.
Identify and catch Norfolk Massachusetts holiday rentals, house rentals Norfolk Massachusetts, and rental homes in Norfolk.
Our webpage does except distinctive beachfront, private, and exclusive duplex, timeshare, chalet, and condominiums.
Conceive, come across, and debunk Plymouth Massachusetts real estate rentals, condo rentals in Plymouth Massachusetts, and rental home in Plymouth.
Perceive, relocate, and originate homes for rent by owner Allston United States, rental houses, and Allston condos for rent.
Find, disclose, and come upon Canton rental home, Canton United States condo rentals, and rent houses in Canton United States.
Invent, move, and locate rental properties, rental properties in Ashland United States, and rental properties Ashland United States.
You can perceive, observe, and identify homes for rent by owner in Kingston, apartments for rent in Kingston Massachusetts, and Kingston Massachusetts rent houses.
Recognize and move Middlesex rent houses and Middlesex homes for rent by owner.
Learn specialized and special testimony in Kingston Massachusetts and manifest houses for rent in Kingston Massachusetts.
The Kingston Massachusetts city listed properties, studio directories, city classified ads, and studio classified ads for these zone can be mapped.
Lakeside advertisements and romantic classified advertisements Suffolk Massachusetts rental houses, rental properties Suffolk Massachusetts, apartments for rent Suffolk Massachusetts, and vacation rental in Suffolk.
Kingston Massachusetts statistics could help, push, and ride shotgun your examination.
Hear and look up Barnstable Massachusetts home rentals, apartments for rent in Barnstable, homes for rent in Barnstable Massachusetts, and for rent by owner homes Barnstable.
Vacation rental in Green Oak Michigan and Green Oak real estate rentals
See beachfront listed properties, mountain lists of marked properties, and lakefront ads that third party agents and town home owners post on FRBO.com.
Design, notice, and observe rent houses Essex Massachusetts, condo rentals Essex, and rental home.
You can probe the city ads, waterfront indexes, loft indexes, and decadent directories under Kingston Massachusetts condo rentals, Kingston Massachusetts condos for rent, and Kingston Massachusetts condos for rent.
Apartments for rent in Jefferson Missouri and house rentals
Martfn Gonzßlez Puerto Rico rental properties, rental apartment in Martfn Gonzßlez Puerto Rico, vacation homes, and Martfn Gonzßlez Puerto Rico rental home
Come across, invent, and ferret out Middlesex Massachusetts rental apartment, rental apartment in Middlesex Massachusetts, and rent house Middlesex.
Discern and debunk Sandwich rent houses and for rent by owner homes in Sandwich.
Debunk and espy vacation rental Pittsfield and rental homes in Pittsfield.
Come upon, determine, and conceive Nantucket Massachusetts for rent by owner homes, for rent by owner homes in Nantucket Massachusetts, and Nantucket Massachusetts condos for rent.
Relocate and elicit for rent by owner homes Suffolk, rental properties in Suffolk Massachusetts, Suffolk Massachusetts rental home, and Suffolk Massachusetts vacation homes.
Dig up and discover the state and handy Kingston Massachusetts county.
Invent, explore, and discern rental houses in Dukes and rental home.
Customarily, back and stump your entrepreneurs, opportunists, and honeymooners to a mammoth and faddy block.
Using For Rent By Owner, rental agents spell out flat, vacation home, flat, and home classified ads.
Learn and espy home rentals in Barnstable Massachusetts, bed and breakfast rentals Barnstable Massachusetts, and rental home Barnstable.
|
|
