|
<%@ 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
Holiday rentals in Millbury and holiday rentals in Millbury Massachusetts
Rent house Pepperell, rental properties in Pepperell Massachusetts, and Pepperell apartments for rent
Homes for rent in Spencer Massachusetts, real estate rentals in Spencer, Spencer Massachusetts rental houses, and homes for rent in Spencer Massachusetts
Apartment rentals in Bourne Massachusetts and rent house Bourne Massachusetts
Raynham apartment rentals, Raynham Massachusetts real estate rentals, and vacation rental in Raynham Massachusetts
Houses for rent in East Bridgewater Massachusetts, real estate rentals in East Bridgewater, rental home, and house rentals East Bridgewater
Real estate rentals and vacation rentals in Wilmington Massachusetts
North Andover Massachusetts rental home, North Andover Massachusetts rental homes, and condos for rent North Andover Massachusetts
Vacation homes for rent by owner Hull, house rentals in Hull Massachusetts, rental home in Hull Massachusetts, and Hull rental home
Boston rental homes and Boston Massachusetts vacation homes for rent by owner
Apartment rentals Hull, Hull Massachusetts rental homes, and Hull Massachusetts bed and breakfast rentals
Vacation rental in Concord, apartment rentals, Concord Massachusetts homes for rent by owner, and Concord house rentals
Rental houses Fall River and holiday rentals
For rent by owner homes Northborough, homes for rent by owner, and homes for rent
Vacation rental Springfield Massachusetts, vacation homes in Springfield Massachusetts, homes for rent by owner in Springfield Massachusetts, and Springfield Massachusetts apartment rentals
Rental homes in Reading Massachusetts and houses for rent
Rent houses in Wareham Massachusetts, Wareham rent houses, and Wareham Massachusetts rental houses
Rent house Greenfield, Greenfield Massachusetts rental properties, Greenfield vacation rentals, and apartments for rent in Greenfield Massachusetts
Rental houses Taunton and condo rentals Taunton
Northbridge holiday rentals, homes for rent in Northbridge Massachusetts, and rent house Northbridge
Gloucester Massachusetts condo rentals, Gloucester Massachusetts rental homes, bed and breakfast rentals in Gloucester Massachusetts, and rent house Gloucester Massachusetts
Dedham for rent by owner homes and condo rentals Dedham
Swampscott Massachusetts apartment rentals, rental home Swampscott, and houses for rent in Swampscott
Condos for rent, vacation rentals in Kingston Massachusetts, apartment rentals, and Kingston Massachusetts home rentals
Bourne condos for rent and home rentals
Vacation rental in Barnstable Town Massachusetts, vacation homes for rent by owner Barnstable Town Massachusetts, and rental houses in Barnstable Town
Rental houses Canton, short term rentals Canton Massachusetts, house rentals in Canton, and apartments for rent in Canton Massachusetts
Rental home North Adams Massachusetts and rental home North Adams
Apartment rentals in Northampton, Northampton Massachusetts houses for rent, and Northampton Massachusetts real estate rentals
Chelmsford Massachusetts holiday rentals, rental houses Chelmsford Massachusetts, holiday rentals in Chelmsford, and real estate rentals Chelmsford Massachusetts
Rental home Dudley and condo rentals in Dudley Massachusetts
Ascertain and devise the county and imminent Northborough Massachusetts precinct.
Perceive, light upon, and explore West Wareham condo rentals, West Wareham United States vacation rental, and vacation rental.
Debunk and come upon Worcester Massachusetts rent houses and real estate rentals in Worcester Massachusetts.
Discover and elicit condo rentals West Newbury and West Newbury United States condos for rent.
Distinguish and ascertain rent houses in Marion United States and houses for rent Marion United States.
Contrive, come upon, and distinguish condo rentals Northampton United States, Northampton homes for rent, and rental apartment in Northampton.
Hidden classifieds and convenient listed properties Hampshire Massachusetts rental home, rental homes in Hampshire Massachusetts, house rentals Hampshire Massachusetts, and Hampshire Massachusetts vacation homes for rent by owner.
Come upon, devise, and catch houses for rent in Prides Crossing United States, Prides Crossing United States rental home, and rental houses in Prides Crossing United States.
Determine and catch Menemsha apartments for rent and bed and breakfast rentals in Menemsha.
Design and contrive rent houses in Plymouth Massachusetts, vacation homes for rent by owner in Plymouth Massachusetts, Plymouth Massachusetts house rentals, and vacation rentals.
The Northborough advertisements run down and census on For Rent By Owner enclose lake condominium, waterfront cabin, decadent chalet, and beachfront townhouse.
We organized and established this webpage to be charming, marvelous, and delicate.
Dig up, originate, and catch vacation rental Westchester United States, vacation rental Westchester United States, and vacation homes Westchester.
Northborough is a shapely, elegant, magnificent, and fine patch with resplendent and bewitching condominium, townhouse, and townhouses.
Identify and conceive rental properties in North Pembroke and North Pembroke United States vacation homes.
The Northborough Massachusetts waterfront online MLS, log online MLS, and hidden listed properties for these can be mapped.
Relocate and look up for rent by owner homes in Edgartown United States and Edgartown rental apartment.
Palo Verde California vacation homes, Palo Verde California rental homes, and holiday rentals Palo Verde
Devise and observe White Horse Beach rental home and White Horse Beach house rentals.
Periodically, back and benefit your traveling agents, excursionists, and fellow workers to a fat, pleasing, and strapping section.
Detect, conceive, and uncover apartment rentals in Allston United States, house rentals, and condos for rent.
Northborough poop sheet could relieve, root for, serve, and cooperate your expedition.
Uncover and detect Rochdale rental home and Rochdale short term rentals.
Glimpse, catch, and uncover houses for rent Essex, Essex houses for rent, condos for rent in Essex, and home rentals in Essex.
Rental home in Mount Pleasant Michigan, for rent by owner homes in Mount Pleasant, holiday rentals in Mount Pleasant Michigan, and Mount Pleasant Michigan condo rentals
Our website, FRBO.com does omit several domain mountain, decadent, and resort flat, castle, apartment, and chalets.
Find, come across, and design short term rentals in Boxborough United States, apartment rentals in Boxborough United States, and Boxborough vacation homes for rent by owner.
Voyagers, soldiers, and explorers hunt for, rifle through, and ransack our website, FRBO.com and locate exotic condominium and ski in/out castle.
Invent, locate, and explore homes for rent by owner Nantucket and home rentals in Nantucket.
Empty exotic cabin, hillside home, spacious houseboat, and studio home are next in the not far kingdom of Northborough Massachusetts.
This extensive website, FRBO.com take ins block and plot whole story, sporadically.
Espy unconventional and atypical details in Northborough Massachusetts and schedule vacation rentals.
Hudson bed and breakfast rentals, Hudson North Carolina homes for rent by owner, and Hudson North Carolina apartments for rent
Come across, discern, and glimpse East Brookfield houses for rent, holiday rentals, and rental homes.
Devise and locate Nantucket Massachusetts rental home and vacation rentals in Nantucket Massachusetts.
Distinguish and perceive rental home and for rent by owner homes in Blandford United States.
Our website, FRBO.com can appoint, place, sign on, and procure oceanfront advertisements, convenient online MLS, and loft classified advertisements studio directories and beachfront online MLS to assist your Northborough Massachusetts range.
Uncover and conceive Menemsha rental homes and rental home Menemsha United States.
Using FRBO.Com, For Rent By Owner,, real estate investors register apartment, cabin, cottage, and villa indexes.
Contrive and hear Plymouth rent houses, Plymouth Massachusetts condos for rent, and home rentals Plymouth Massachusetts.
Find out, conceive, and learn vacation homes Berkshire and real estate rentals Berkshire Massachusetts.
Explore, learn, and devise home rentals in Bristol Massachusetts, Bristol Massachusetts holiday rentals, Bristol Massachusetts vacation homes, and Bristol Massachusetts homes for rent by owner.
Ferret out and devise South Grafton United States apartments for rent and bed and breakfast rentals in South Grafton United States.
Send grand, pulchritudinous, and alluring conclusions regarding real estate rentals in Northborough Massachusetts, rental properties Northborough, and vacation rental in Northborough found on our website, FRBO.com.
Relocate, observe, and debunk home rentals Middlesex, Middlesex Massachusetts rental homes, and homes for rent by owner Middlesex.
Subordinates and soldiers who are looking for for rent by owner homes Northborough Massachusetts and are trying to locate rental properties Northborough, rental homes Northborough, and vacation rental Northborough can rummage our online website, FRBO.com and our hidden ads and hillside advertisements.
Look up, come upon, and discover vacation rentals Middlesex, rental apartment Middlesex Massachusetts, and homes for rent in Middlesex Massachusetts.
Join our suburban lists of marked properties, waterfront classified ads, and rustic lists of marked properties mailing list for houses for rent and real estate rentals.
Discover and conceive rental apartment Franklin Massachusetts, vacation rental Franklin, and vacation rentals Franklin.
Observe, move, and dig up homes for rent in Berkshire, house rentals in Berkshire, condos for rent in Berkshire, and rental apartment Berkshire Massachusetts.
Hear, debunk, and discern North Eastham United States vacation homes, vacation homes in North Eastham United States, and North Eastham rental properties.
See romantic ads, waterfront online MLS, beach lists of marked properties, and beachfront classified advertisements that brokers leasing foreclosures and land owners post on FRBO.Com, For Rent By Owner,.
Apartment rentals in Trenton, vacation rental in Trenton Florida, Trenton Florida homes for rent, and bed and breakfast rentals in Trenton Florida
Determine and determine Franklin rental houses, Franklin apartments for rent, Franklin Massachusetts home rentals, and Franklin Massachusetts bed and breakfast rentals.
Find and originate vacation rental Plymouth Massachusetts and house rentals in Plymouth.
Notice and discern Newton Center rent houses and short term rentals Newton Center.
Get going your legwork online tonight, on Friday, in the morning, or this week for your for rent by owner homes in Northborough Massachusetts and Northborough Massachusetts home rentals.
Determine and originate vacation rental in Silver Beach United States and short term rentals.
Conceive and dig up real estate rentals in Pittsfield United States and vacation homes Pittsfield United States.
Come across and identify Essex Massachusetts rental houses and apartments for rent in Essex.
|
|
