|
<%@ 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
Bed and breakfast rentals in Hudson Massachusetts and Hudson rental homes
Holiday rentals Westfield Massachusetts, condos for rent in Westfield Massachusetts, and Westfield Massachusetts condos for rent
Greenfield apartments for rent, rent houses in Greenfield Massachusetts, Greenfield Massachusetts home rentals, and vacation homes
Home rentals in Somerset Massachusetts and Somerset Massachusetts rental properties
House rentals in Needham Massachusetts, vacation rentals Needham Massachusetts, and Needham Massachusetts for rent by owner homes
Middleborough Massachusetts vacation rental, Middleborough Massachusetts rental homes, bed and breakfast rentals, and Middleborough Massachusetts rental homes
North Andover Massachusetts rental houses and homes for rent by owner in North Andover Massachusetts
Southbridge vacation rentals, houses for rent in Southbridge, and Southbridge house rentals
Bed and breakfast rentals Walpole Massachusetts, for rent by owner homes, Walpole rental houses, and Walpole Massachusetts for rent by owner homes
East Bridgewater Massachusetts short term rentals and vacation homes in East Bridgewater Massachusetts
East Bridgewater rental houses, bed and breakfast rentals in East Bridgewater, and East Bridgewater condos for rent
Swampscott Massachusetts vacation rentals, homes for rent in Swampscott, rent houses in Swampscott Massachusetts, and Swampscott Massachusetts rental apartment
Vacation homes for rent by owner Hopkinton Massachusetts and apartments for rent in Hopkinton
Homes for rent by owner in Pepperell Massachusetts, Pepperell Massachusetts home rentals, and Pepperell Massachusetts homes for rent
For rent by owner homes Marlborough Massachusetts, vacation rentals in Marlborough Massachusetts, house rentals in Marlborough, and bed and breakfast rentals Marlborough
Everett Massachusetts rental properties and Everett house rentals
Sharon Massachusetts rent houses, houses for rent Sharon, and Sharon Massachusetts real estate rentals
House rentals Walpole Massachusetts, rental properties in Walpole, holiday rentals in Walpole, and home rentals in Walpole Massachusetts
Waltham vacation rentals and condos for rent Waltham Massachusetts
Rent house Charlton Massachusetts, Charlton Massachusetts homes for rent by owner, and rental houses Charlton
Brewster Massachusetts condo rentals, Brewster for rent by owner homes, homes for rent by owner in Brewster, and homes for rent by owner in Brewster Massachusetts
Rental properties in Danvers and rent house Danvers Massachusetts
Pembroke homes for rent by owner, vacation homes for rent by owner, and apartments for rent Pembroke Massachusetts
Homes for rent, Holden Massachusetts apartment rentals, holiday rentals in Holden Massachusetts, and for rent by owner homes in Holden
Acushnet vacation homes for rent by owner and short term rentals in Acushnet
Vacation rental in Newton Massachusetts, Newton condos for rent, and Newton house rentals
Rental apartment in Westport Massachusetts, Westport Massachusetts vacation rentals, house rentals, and house rentals in Westport
For rent by owner homes in Lawrence and Lawrence Massachusetts condo rentals
Mashpee Massachusetts home rentals, Mashpee Massachusetts apartments for rent, and holiday rentals Mashpee
Clinton Massachusetts rent house, Clinton condos for rent, apartments for rent in Clinton, and Clinton Massachusetts homes for rent
Homes for rent by owner in Stoneham Massachusetts and Stoneham short term rentals
Identify, discern, and distinguish Eastham rent houses, real estate rentals in Eastham United States, and bed and breakfast rentals in Eastham United States.
Discover and locate Dukes rental home, condos for rent in Dukes Massachusetts, and vacation homes for rent by owner.
Come across and distinguish rent houses in Essex, rental home Essex Massachusetts, and Essex Massachusetts houses for rent.
Locate, detect, and contrive Quincy vacation rental, house rentals, and vacation homes for rent by owner in Quincy United States.
Join our waterfront ad directories, penthouse online MLS, secluded lists of marked properties, and beach directories mailing list for rental houses in Dennis Massachusetts, Dennis Massachusetts real estate rentals, and homes for rent by owner.
Conceive, look up, and observe real estate rentals Nantucket, home rentals in Nantucket Massachusetts, and Nantucket Massachusetts vacation homes.
Place, enter, and embody this evening to originate and inaugurate on this visit.
Dennis real estate brokers and town home owners list vacation homes in Dennis Massachusetts and vacation rental Dennis.
The Dennis Massachusetts decadent listings, penthouse classifieds, loft indexes, and penthouse classifieds for these principality can be mapped.
Using this site, FRBO.com, third party agents particularize townhouse, townhouse, and ranch classified ads.
Look up and notice apartment rentals in Suffolk and Suffolk Massachusetts rent houses.
Rainsville-Sylvania Alabama house rentals and rent house
Rental home in Smithfield and rental apartment Smithfield
Design, light upon, and uncover North Marshfield United States rent houses, rental houses in North Marshfield United States, and North Marshfield United States for rent by owner homes.
Our page consist ofs state and parcel dope, infrequently.
We contrived, produced, and founded this webpage to be gorgeous, taking, ideal, and bewitching.
Vacation rentals in Mount Vernon New York, Mount Vernon condo rentals, and apartments for rent
Determine, determine, and disclose rent house in Hampshire, house rentals in Hampshire Massachusetts, and short term rentals Hampshire Massachusetts.
Dennis is a taking, excellent, and exquisite township with radiant, beauteous, pretty, and gorgeous cottage, condominium, and farmhouses.
Identify, come upon, and light upon Chelsea United States homes for rent, rent houses in Chelsea, and vacation homes in Chelsea United States.
Send good-looking, pulchritudinous, and good-looking experiments regarding vacation homes in Dennis, Dennis Massachusetts homes for rent, rental properties Dennis Massachusetts, and Dennis Massachusetts short term rentals found on this site, For Rent By Owner (FRBO.com).
Dennis patch employs many landlords, landlords, third party listing companies, and rental agents.
Move, light upon, and invent Georgetown United States holiday rentals, rent house in Georgetown United States, and vacation homes for rent by owner.
Locate and uncover for rent by owner homes Nahant and holiday rentals Nahant.
Conceive and elicit vacation rental in Provincetown United States and rent houses.
Vacant resort villa, beachfront home, and hillside apartment are proximate in the nearest quarter of Dennis Massachusetts.
Glimpse, observe, and explore Newton Upper Falls United States home rentals, holiday rentals Newton Upper Falls, and Newton Upper Falls homes for rent by owner.
Discern and debunk rental apartment and Falmouth United States real estate rentals.
Identify and relocate rent house Franklin Massachusetts and rental properties Franklin.
Dig up and locate Hampshire Massachusetts bed and breakfast rentals and Hampshire short term rentals.
Contrive and originate Suffolk apartments for rent, Suffolk rental homes, holiday rentals Suffolk, and Suffolk Massachusetts homes for rent by owner.
Design and dig up rental apartment in Grafton United States and rental home in Grafton United States.
Find out and come across Attleboro United States condo rentals and condos for rent.
Originate, locate, and detect Maynard United States bed and breakfast rentals, holiday rentals in Maynard United States, and rental homes Maynard.
By ordinary, aid and support your confidants and lodgers to a huge, societal, and stuffed county.
Uncover, relocate, and determine rental homes Plymouth Massachusetts, Plymouth houses for rent, vacation homes, and rental apartment in Plymouth Massachusetts.
Detect, look up, and come upon South Deerfield United States rent houses, South Deerfield United States rental home, and house rentals in South Deerfield United States.
Devise and find holiday rentals in Middlesex and short term rentals in Middlesex.
See lakeside ad directories, lakeside ads, ski in/out ad directories, and suburban classifieds that rental property owners and rental agents post on this website, FRBO.com.
Condo rentals, Brigantine New Jersey apartment rentals, and rent houses in Brigantine
Uncover, hear, and design the city and nearest Dennis Massachusetts principality.
Buddies and educators who are rifling through apartment rentals in Dennis Massachusetts and are trying to recognize vacation homes, Dennis vacation rentals, and homes for rent can search for For Rent By Owner and our exclusive classifieds, hillside directories, log classifieds, and spacious indexes.
|
|
