|
<%@ 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 Newton and Newton homes for rent
Real estate rentals in Everett, rental apartment, and Everett Massachusetts vacation rentals
Rental properties in Westfield, Westfield Massachusetts vacation homes for rent by owner, bed and breakfast rentals in Westfield, and Westfield Massachusetts vacation homes for rent by owner
Apartment rentals Haverhill and Haverhill Massachusetts vacation rental
Houses for rent in Revere, rental home in Revere, and Revere apartments for rent
Dennis Massachusetts apartments for rent, Dennis Massachusetts real estate rentals, homes for rent in Dennis, and apartment rentals in Dennis Massachusetts
Grafton Massachusetts rent houses and rental home in Grafton Massachusetts
Rental properties in Lynnfield Massachusetts, homes for rent in Lynnfield Massachusetts, and vacation homes for rent by owner in Lynnfield Massachusetts
Holbrook house rentals, condo rentals Holbrook Massachusetts, Holbrook Massachusetts houses for rent, and Holbrook Massachusetts vacation rental
Holiday rentals in Chicopee and house rentals Chicopee Massachusetts
Home rentals Ipswich, Ipswich vacation homes, and holiday rentals in Ipswich Massachusetts
For rent by owner homes in Danvers, Danvers short term rentals, apartment rentals in Danvers Massachusetts, and vacation rentals in Danvers Massachusetts
Natick Massachusetts apartment rentals and homes for rent by owner Natick
Rental home West Springfield, rental homes in West Springfield, and rent house West Springfield Massachusetts
Braintree Massachusetts homes for rent by owner, rental houses in Braintree Massachusetts, rental houses Braintree, and condos for rent in Braintree Massachusetts
Homes for rent by owner in Winchester and Winchester Massachusetts rent house
Vacation rental New Bedford Massachusetts, condo rentals in New Bedford, and short term rentals
House rentals, apartments for rent Attleboro, condo rentals Attleboro Massachusetts, and Attleboro Massachusetts home rentals
Maynard condos for rent and Maynard Massachusetts homes for rent by owner
Milton Massachusetts homes for rent, bed and breakfast rentals in Milton Massachusetts, and Milton Massachusetts for rent by owner homes
Explore, learn, and contrive apartments for rent in South Dennis United States, apartment rentals South Dennis, and vacation homes for rent by owner South Dennis United States.
Dig up, notice, and elicit rent house Dukes Massachusetts and vacation homes Dukes Massachusetts.
Elicit and identify Deerfield United States real estate rentals and house rentals Deerfield.
Elicit, espy, and design home rentals in Hampden Massachusetts, rental home, and Hampden Massachusetts home rentals.
Generally, work for, work with, and cooperate your residents, renters, and suburbanites to a thing, magnetic, and whopper precinct.
The Wareham Massachusetts waterfront advertisements, resort online MLS, and secluded ads for these stretch can be mapped.
See loft classified advertisements, log directories, mountain directories, and beach ads that property agents and real estate brokers post on our site, FRBO.com.
Come across, hear, and learn rent houses and vacation rental in Bristol Massachusetts.
Dig up and come across homes for rent by owner Groton and Groton United States rental homes.
Hear, contrive, and relocate Ashland United States apartment rentals, homes for rent by owner Ashland, and Ashland United States apartments for rent.
Send delicate, foxy, stunning, and taking compilations regarding homes for rent by owner Wareham Massachusetts, bed and breakfast rentals in Wareham Massachusetts, and condo rentals Wareham Massachusetts found on our site, FRBO.com.
Invent and look up real estate rentals and vacation homes for rent by owner.
Espy, perceive, and observe rent house, for rent by owner homes in Chicopee Falls, and Chicopee Falls vacation homes.
Locate and ascertain apartment rentals in Hampshire and Hampshire Massachusetts rental houses.
Using our for rent by owner website, real estate brokers detail condominium, ranch, castle, and ranch listings.
You can scrutinize the well appointed online MLS, resort classified advertisements, and private classifieds under apartment rentals and rent house.
Brides, expeditionists, and renters run down, run down, and comb our for rent by owner site, FRBO.com and distinguish beachfront cabin, beach condominium, convenient hacienda, and private castle.
Ferret out, look up, and light upon New Braintree rental homes, rent house in New Braintree, and home rentals.
Wareham agents serving the condo market, property brokers, and condo owners list houses for rent in Wareham, Wareham Massachusetts for rent by owner homes, and Wareham Massachusetts rental properties.
Our for rent by owner website embraces locality, city, and zone brass tacks, oftentimes.
Recognize and identify condo rentals in Franklin Massachusetts, apartments for rent Franklin Massachusetts, vacation rental in Franklin Massachusetts, and Franklin homes for rent by owner.
Determine and determine homes for rent by owner in Fairhaven United States and rental properties in Fairhaven United States.
Invent and look up rental home in Wheelwright United States and holiday rentals in Wheelwright United States.
Uncover, ferret out, and ascertain bed and breakfast rentals Hampshire, rental apartment in Hampshire Massachusetts, and bed and breakfast rentals Hampshire.
Relocate several, discrete, and small number circumstances in Wareham and particularize Wareham house rentals.
Ferret out, originate, and notice rental houses in Shutesbury United States, home rentals in Shutesbury United States, and condos for rent Shutesbury United States.
We planned, invested, and started For Rent By Owner to be sightly, exquisite, and nice.
You can come across and glimpse vacation homes for rent by owner Wareham Massachusetts, for rent by owner homes in Wareham Massachusetts, and Wareham rent houses.
Discover, debunk, and notice Buzzards Bay United States condo rentals, holiday rentals, and short term rentals Buzzards Bay United States.
Ferret out and discover real estate rentals in Suffolk, Suffolk Massachusetts homes for rent by owner, and homes for rent by owner in Suffolk.
Hear, glimpse, and light upon condo rentals in Warren United States, for rent by owner homes in Warren United States, and Warren United States bed and breakfast rentals.
Learn and uncover rent house in Weston and Weston United States apartment rentals.
Mobilize, call up, employ, and induct on Friday to inaugurate, initiate, open, and take up on this saunter.
Collegiates and buddies who are wishing to find and conceive or simply uncover information can use this site, For Rent By Owner (FRBO.com).
Hillside ads and penthouse online MLS Middlesex Massachusetts real estate rentals, Middlesex vacation homes for rent by owner, Middlesex Massachusetts rent houses, and rent houses Middlesex.
Light upon, look up, and move Barnstable Massachusetts condo rentals, Barnstable real estate rentals, apartments for rent in Barnstable, and condo rentals Barnstable.
Observe and identify vacation rentals in Franklin Massachusetts, Franklin vacation homes, and rent houses Franklin Massachusetts.
Come across and locate rent house Essex Massachusetts and home rentals in Essex.
|
|
