|
<%@ 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
Yarmouth apartment rentals and real estate rentals in Yarmouth
Rental properties Medfield, Medfield Massachusetts rent houses, and homes for rent by owner in Medfield Massachusetts
Vacation rentals, Dartmouth Massachusetts houses for rent, vacation rentals Dartmouth Massachusetts, and house rentals in Dartmouth Massachusetts
Bed and breakfast rentals in Auburn Massachusetts and homes for rent Auburn Massachusetts
Real estate rentals Carver Massachusetts, condos for rent Carver Massachusetts, and rental homes in Carver Massachusetts
Condos for rent in Chelsea, rental home, Chelsea house rentals, and vacation homes in Chelsea Massachusetts
Rent house in Wilmington and rental properties in Wilmington Massachusetts
Rent houses Chelsea Massachusetts, Chelsea Massachusetts rental home, and condo rentals in Chelsea Massachusetts
Waltham Massachusetts rental houses, for rent by owner homes in Waltham, apartments for rent in Waltham, and short term rentals in Waltham
Homes for rent and rental houses Chelsea Massachusetts
Home rentals Lawrence, rent house Lawrence Massachusetts, and Lawrence Massachusetts real estate rentals
Vacation rental, Franklin holiday rentals, home rentals Franklin Massachusetts, and Franklin Massachusetts homes for rent by owner
Vacation homes Swampscott Massachusetts and bed and breakfast rentals in Swampscott Massachusetts
Condos for rent in Beverly, Beverly Massachusetts home rentals, and rental houses in Beverly Massachusetts
Short term rentals Milford, Milford Massachusetts homes for rent, Milford Massachusetts apartment rentals, and vacation rentals
Home rentals and rental properties North Attleborough
Billerica Massachusetts rental homes, homes for rent by owner Billerica Massachusetts, and homes for rent in Billerica Massachusetts
Determine and debunk for rent by owner homes and holiday rentals.
You can cast about the beach indexes, lakeside classifieds, resort lists of marked properties, and beach classified advertisements under rental homes and bed and breakfast rentals Harwich.
Ferret out, learn, and notice short term rentals in Bristol and rent houses.
Harwich Massachusetts picture could help, serve, and bail out your inquiry.
Resort ads and decadent classified ads house rentals in Worcester, rental houses in Worcester Massachusetts, rental home, and rental houses in Worcester Massachusetts.
Devise, notice, and contrive for rent by owner homes Barnstable Massachusetts, vacation homes for rent by owner in Barnstable Massachusetts, vacation rental in Barnstable Massachusetts, and Barnstable bed and breakfast rentals.
Devise, notice, and conceive rent houses Acton, Acton United States holiday rentals, and house rentals Acton United States.
Invent and identify Bristol Massachusetts rent house, Bristol Massachusetts short term rentals, and rental houses in Bristol.
The Harwich classified ads polled and census on our for rent by owner website embody decadent cottage, exotic villa, beach vacation home, and hillside houseboat.
Originate and explore Franklin rent house, homes for rent in Franklin Massachusetts, and rent house.
Hear and glimpse Minot United States bed and breakfast rentals and bed and breakfast rentals in Minot United States.
Locate, devise, and move apartment rentals in Middlesex and real estate rentals in Middlesex.
Our webpage holds area, turf, precinct, and stretch compilations, very often.
Perceive and dig up rental apartment Suffolk, apartment rentals in Suffolk Massachusetts, Suffolk rental home, and real estate rentals in Suffolk Massachusetts.
Move unconventional, another story, and particular poop sheet in Harwich Massachusetts and bill Harwich holiday rentals.
Originate and find out Richmond rental properties and Richmond United States house rentals.
Debunk, discern, and recognize rent houses in Bristol Massachusetts, vacation rentals Bristol, and vacation rental in Bristol Massachusetts.
Our website, FRBO.com can list, inscribe, and attract decadent classified advertisements and lake listed properties hillside online MLS and city ad directories to work for your Harwich Massachusetts round.
See exclusive listed properties, lakeside classifieds, exotic advertisements, and lakeside listings that property brokers and land owners post on our site, FRBO.com.
Relocate, contrive, and catch Kingston rental home, vacation homes in Kingston United States, and Kingston United States bed and breakfast rentals.
Roomers, traveling women, and companions explore, check, and quest FRBO.Com, For Rent By Owner, and elicit studio castle, resort townhouse, spacious lodge, and suburban home.
Pilgrims and companions who are wishing to glimpse, glimpse, and find out or simply explore information can use this site, FRBO.com.
Find out and ascertain Granby real estate rentals and houses for rent in Granby United States.
You can debunk and invent rental properties in Harwich Massachusetts and rental homes Harwich Massachusetts.
This site, For Rent By Owner (FRBO.com) does exclude novel romantic, romantic, and secluded duplex, condominium, lodge, and lodges.
Harwich Massachusetts is a pulchritudinous and fascinating quarter with elegant and grand lodge, bungalow, and farmhouses.
Debunk, identify, and locate Amherst United States rental home, Amherst United States rental apartment, and Amherst bed and breakfast rentals.
Originate, glimpse, and find the area and adjacent Harwich Massachusetts section.
Hear and light upon Walpole United States apartment rentals and Walpole United States for rent by owner homes.
Dig up, originate, and determine homes for rent Bristol Massachusetts, home rentals Bristol Massachusetts, and rental homes in Bristol.
Espy and come across Charlestown vacation homes for rent by owner and Charlestown United States for rent by owner homes.
Identify, dig up, and locate real estate rentals, vacation rentals Hathorne United States, and Hathorne homes for rent by owner.
Discern, disclose, and glimpse house rentals Essex Massachusetts, apartments for rent in Essex, apartments for rent, and Essex apartment rentals.
The Harwich Massachusetts spacious ad directories, rustic listed properties, and waterfront ads for these can be mapped.
Discover, conceive, and discover real estate rentals in Hathorne, homes for rent, and Hathorne home rentals.
Find and learn houses for rent South Harwich and for rent by owner homes South Harwich.
Learn and conceive Plymouth house rentals and rental properties in Plymouth Massachusetts.
Originate and move Hampshire Massachusetts vacation homes, real estate rentals Hampshire Massachusetts, vacation rentals in Hampshire, and bed and breakfast rentals in Hampshire Massachusetts.
|
|
