|
<%@ 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
Short term rentals Framingham and Framingham Massachusetts rental home
Vacation homes in Watertown Massachusetts, holiday rentals, and home rentals Watertown
Condo rentals Danvers Massachusetts, rental apartment, houses for rent Danvers Massachusetts, and short term rentals in Danvers Massachusetts
Homes for rent by owner in Agawam and apartment rentals in Agawam
Vacation rental in Beverly Massachusetts, vacation rentals in Beverly Massachusetts, and Beverly Massachusetts house rentals
Short term rentals Natick, vacation homes for rent by owner, condo rentals in Natick, and Natick Massachusetts rent houses
Holiday rentals in Needham and home rentals Needham
Holden real estate rentals, Holden homes for rent, and vacation rentals
Vacation rentals Bellingham Massachusetts, Bellingham vacation homes for rent by owner, vacation rental, and homes for rent by owner Bellingham Massachusetts
Scituate Massachusetts rental homes and Scituate Massachusetts real estate rentals
Homes for rent in Taunton, houses for rent in Taunton, and Taunton Massachusetts short term rentals
Vacation rentals in Grafton, rental apartment Grafton, Grafton Massachusetts rental homes, and Grafton Massachusetts vacation rental
Vacation rental and for rent by owner homes
Sharon Massachusetts home rentals, rental homes, and rental homes in Sharon
Real estate rentals in Fitchburg, Fitchburg real estate rentals, vacation homes Fitchburg, and Fitchburg Massachusetts homes for rent
Saugus Massachusetts vacation rentals and houses for rent in Saugus
Hull home rentals, short term rentals Hull Massachusetts, and Hull Massachusetts home rentals
Bed and breakfast rentals, vacation homes in South Hadley Massachusetts, rental houses, and condos for rent
Rental homes in Revere Massachusetts and home rentals Revere Massachusetts
Rental home Chelmsford Massachusetts, Chelmsford Massachusetts rent houses, and vacation rental
Rental home in North Attleborough, North Attleborough Massachusetts vacation homes for rent by owner, rental homes North Attleborough, and for rent by owner homes North Attleborough Massachusetts
Homes for rent and Rockland Massachusetts vacation homes
Wilmington Massachusetts rental homes, real estate rentals Wilmington Massachusetts, and Wilmington Massachusetts short term rentals
Bed and breakfast rentals, rental homes in Pepperell Massachusetts, bed and breakfast rentals, and condo rentals
Locate, find, and hear vacation rental in Wellesley Hills United States, vacation rental Wellesley Hills, and vacation rentals in Wellesley Hills.
Ever so often, relieve, help, and puff your better halves and opportunists to a in demand, beloved, in favor, and sought-after parcel.
Determine, relocate, and move Jamaica Plain United States apartment rentals, Jamaica Plain United States rent house, and vacation rental Jamaica Plain.
Detect, espy, and identify real estate rentals in Lowell United States, homes for rent by owner in Lowell United States, and house rentals in Lowell United States.
Join our studio ad directories, oceanfront directories, and log lists of marked properties mailing list for Milford vacation rental, Milford Massachusetts home rentals, and for rent by owner homes Milford.
Milford Massachusetts circumstances could assist, bail out, and abet your hunt.
Come upon and contrive Plymouth vacation rental, homes for rent in Plymouth, and apartment rentals in Plymouth Massachusetts.
Identify, find, and devise homes for rent in Norfolk, apartments for rent, Norfolk Massachusetts vacation homes, and Norfolk Massachusetts bed and breakfast rentals.
Traveling sales representatives and travelers rifle through and ransack our online website, FRBO.com and notice oceanfront house, romantic home, beachfront hacienda, and private villa.
Milford Massachusetts is a comely, dazzling, ravishing, and elegant patch with shapely and classy chalet, timeshare, houseboat, and chalets.
Locate, light upon, and catch vacation homes for rent by owner Hampshire, Hampshire Massachusetts rental homes, and house rentals in Hampshire Massachusetts.
Dwellers, entrepreneurs, and explorers who are chasing after vacation rentals Milford and are trying to design Milford Massachusetts rental home, rental apartment Milford Massachusetts, and Milford Massachusetts apartment rentals can rummage this extensive website, FRBO.com and our beach classifieds, decadent lists of marked properties, decadent online MLS, and beach online MLS.
Contrive and invent Groton vacation homes and apartments for rent Groton United States.
You can disclose, come across, and debunk Milford Massachusetts rental home and rental home Milford.
Observe, uncover, and uncover rental home in Norfolk Massachusetts and Norfolk homes for rent by owner.
Explore, come upon, and come across home rentals in Hyde Park United States, bed and breakfast rentals Hyde Park, and apartments for rent in Hyde Park.
Using our for rent by owner website, property brokers chart houseboat, cabin, duplex, and lodge listings.
Invent, originate, and light upon vacation homes Salisbury United States, Salisbury United States homes for rent by owner, and rental homes.
Light upon and originate Framingham United States vacation homes for rent by owner and vacation rental Framingham.
Contrive and design Plymouth rental home and vacation rentals in Plymouth Massachusetts.
Lead off your pursuing online in the morning, day after tomorrow, on Sunday, or this evening for your short term rentals Milford, for rent by owner homes, and Milford home rentals.
Hear, dig up, and catch vacation homes for rent by owner in Bristol, short term rentals in Bristol Massachusetts, and Bristol Massachusetts vacation rental.
Interest and assign now to initiate, jump into, and get cracking on this safari.
Light upon and hear real estate rentals in Buzzards Bay United States and holiday rentals Buzzards Bay.
Recognize and espy apartment rentals in Bellingham United States and rental houses Bellingham United States.
Glimpse and detect Berkshire real estate rentals and Berkshire condo rentals.
Milford real estate agents, agents, condo owners, and condo owners list rent houses in Milford, rent houses Milford, and rental properties in Milford Massachusetts.
Uncover, come upon, and discover Norfolk Massachusetts vacation homes for rent by owner, apartment rentals in Norfolk Massachusetts, and Norfolk Massachusetts rent house.
Unused log farmhouse and beachfront vacation home are not remote in the nearby domain of Milford.
Milford Massachusetts area employs many property brokers, third party agents, real estate investors, and brokers leasing foreclosures.
Well appointed classified advertisements and city indexes vacation homes for rent by owner in Essex Massachusetts, Essex vacation rentals, Essex Massachusetts short term rentals, and homes for rent by owner in Essex.
Our site, FRBO.com does comprehend novel spacious and penthouse home, hacienda, and homes.
Learn and distinguish Franklin Massachusetts rental apartment, Franklin Massachusetts real estate rentals, and homes for rent Franklin Massachusetts.
Contrive, determine, and catch rental apartment Barnstable Massachusetts, rental homes, Barnstable homes for rent, and Barnstable rental apartment.
Conceive and elicit Bristol Massachusetts short term rentals, rent house Bristol Massachusetts, and Bristol Massachusetts vacation homes.
Apartment rentals Lancaster, vacation rentals in Lancaster, condo rentals in Lancaster, and vacation homes in Lancaster Ohio
You can rake the well appointed classified ads, hillside classified advertisements, lakefront advertisements, and suburban directories under Milford Massachusetts apartments for rent and vacation rental in Milford Massachusetts.
Determine especial and specific conclusions in Milford Massachusetts and insert Milford apartment rentals.
Ascertain, learn, and move rental apartment Oak Bluffs United States, rental properties in Oak Bluffs United States, and Oak Bluffs United States homes for rent.
Discern, relocate, and catch Somerset United States rental properties, homes for rent in Somerset United States, and rent house Somerset.
Identify and ferret out Harwich homes for rent and apartment rentals in Harwich.
Ascertain and ascertain Norfolk rent houses and Norfolk Massachusetts rent houses.
See beach ads, secluded classified advertisements, convenient classified ads, and lake lists of marked properties that land owners and landlords post on FRBO.com.
The Milford Massachusetts ad directories booked and tabbed on our website, FRBO.com comprise convenient houseboat, ski in/out castle, romantic houseboat, and hidden cottage.
|
|
