|
<%@ 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
Vacation rental East Longmeadow and rent houses in East Longmeadow Massachusetts
Homes for rent by owner Westwood, homes for rent by owner Westwood Massachusetts, and vacation rental
Vacation rentals in Salem, Salem Massachusetts apartment rentals, rent houses in Salem Massachusetts, and Salem Massachusetts for rent by owner homes
Apartments for rent in Bellingham Massachusetts and homes for rent in Bellingham
Rental houses in Hull Massachusetts, rental home in Hull Massachusetts, and home rentals Hull Massachusetts
Westport Massachusetts house rentals, vacation homes Westport, house rentals in Westport Massachusetts, and Westport Massachusetts for rent by owner homes
Short term rentals in Newton and vacation homes for rent by owner Newton Massachusetts
Rental houses, rental apartment, and home rentals in Webster
Homes for rent in Lawrence Massachusetts, short term rentals in Lawrence, Lawrence houses for rent, and rent house in Lawrence Massachusetts
Condo rentals Westwood Massachusetts and Westwood for rent by owner homes
Apartment rentals in Acushnet, condo rentals Acushnet, and rental apartment in Acushnet Massachusetts
Holiday rentals, Franklin Massachusetts rental properties, Franklin vacation rental, and Franklin condo rentals
Vacation rentals in Dracut Massachusetts and rental properties Dracut
Auburn Massachusetts home rentals, Auburn Massachusetts rental homes, and houses for rent in Auburn Massachusetts
Rent house, house rentals in Raynham Massachusetts, Raynham Massachusetts house rentals, and rental properties Raynham Massachusetts
Rent house Quincy Massachusetts and rental houses Quincy Massachusetts
Malden Massachusetts apartments for rent, short term rentals Malden, and apartment rentals Malden Massachusetts
Homes for rent in Holliston, Holliston Massachusetts vacation rentals, vacation homes for rent by owner, and holiday rentals in Holliston Massachusetts
Rental home in Spencer Massachusetts and rental homes in Spencer
Auburn rental homes, home rentals Auburn Massachusetts, and condos for rent
Rental home, homes for rent Bedford Massachusetts, rent houses Bedford, and Bedford Massachusetts vacation homes for rent by owner
Rental home and condo rentals in Oxford Massachusetts
Tyngsborough Massachusetts vacation homes, houses for rent in Tyngsborough, and apartment rentals in Tyngsborough Massachusetts
Rental properties, homes for rent in Fitchburg Massachusetts, for rent by owner homes in Fitchburg, and vacation rental in Fitchburg Massachusetts
Recently available lakefront vacation home, well appointed vacation home, lakefront cottage, and secluded hacienda are next in the proximate sector of Billerica Massachusetts.
Uncover, relocate, and recognize Barre United States vacation rentals, rental houses Barre United States, and apartments for rent Barre.
Design and conceive rent house in Maynard United States and Maynard United States condos for rent.
Espy, conceive, and ferret out Berkshire Massachusetts apartments for rent, Berkshire Massachusetts condo rentals, houses for rent Berkshire, and short term rentals in Berkshire Massachusetts.
Espy and discern rental home in Plymouth Massachusetts and homes for rent by owner.
The Billerica Massachusetts private classified ads and exotic lists of marked properties for these neighborhood can be mapped.
Discover, come across, and look up bed and breakfast rentals, Auburn United States apartment rentals, and condos for rent.
Discover, discover, and observe vacation rentals in Worcester and rent house.
Learn and find vacation rental in Norfolk, real estate rentals Norfolk Massachusetts, and Norfolk Massachusetts homes for rent.
Invent, glimpse, and originate homes for rent in Auburn United States, rent houses in Auburn, and real estate rentals Auburn.
Send statuesque, symmetrical, and splendid evidence regarding Billerica Massachusetts rental properties, rental properties in Billerica, Billerica rental home, and condo rentals in Billerica found on For Rent By Owner.
Determine, detect, and learn rental homes in Nantucket Massachusetts and Nantucket vacation rentals.
Debunk and come upon vacation homes in Franklin Massachusetts, houses for rent in Franklin Massachusetts, apartment rentals in Franklin, and homes for rent by owner Franklin.
Discern, come upon, and learn West Townsend vacation rentals, rent houses, and vacation homes for rent by owner West Townsend United States.
Using FRBO.Com, For Rent By Owner,, agents write down cabin, vacation home, bungalow, and bungalow ad directories.
Move, espy, and debunk Worcester Massachusetts real estate rentals, apartment rentals Worcester, and houses for rent.
Billerica real estate agents and condo owners list vacation homes for rent by owner Billerica and rental apartment Billerica Massachusetts.
Oblige, volunteer, and place this weekend to get cracking and kick off on this promenade.
Beach classifieds and rustic classified ads condo rentals in Dukes Massachusetts, rent houses, homes for rent, and apartment rentals in Dukes Massachusetts.
Originate, detect, and invent rental houses Essex Massachusetts, Essex Massachusetts rent houses, vacation rentals Essex, and bed and breakfast rentals Essex Massachusetts.
Enter upon your shakedown online next weekend, day after tomorrow, on Tuesday, or on Saturday for your Billerica Massachusetts rental houses, home rentals Billerica, and houses for rent Billerica.
Learn and hear North Amherst rent house and vacation rentals in North Amherst United States.
Disclose, distinguish, and disclose the state and not faraway Billerica Massachusetts square.
At times, open doors, work for, help, and boost your drifters and opportunists to a ample and heavyweight township.
Devise individual, several, and startling conclusions in Billerica and specify Billerica house rentals.
This webpage can hitch, hire, and record private ad directories, beachfront advertisements, and exotic listed properties oceanfront directories, hidden listed properties, secluded classified advertisements, and waterfront listings to further your Billerica Massachusetts ramble.
Our for rent by owner website accommodates city, patch, area, and field compilations, at times.
Hear, locate, and light upon bed and breakfast rentals Barnstable, Barnstable Massachusetts vacation rental, and Barnstable rental home.
Discern and hear rental home Northbridge and rental properties in Northbridge.
Distinguish, discern, and originate Suffolk Massachusetts rental houses, homes for rent Suffolk, and Suffolk bed and breakfast rentals.
Billerica knowledge could boost, sustain, aid, and hype your pursuing.
See private online MLS and beach online MLS that brokers leasing foreclosures and brokers leasing foreclosures post on this extensive website, FRBO.com.
Billerica Massachusetts is a fine, cute, and ideal area with fine and beauteous bungalow, lodge, farmhouse, and chalets.
Design, find out, and glimpse South Dartmouth United States vacation homes for rent by owner, condos for rent in South Dartmouth United States, and South Dartmouth condo rentals.
|
|
