|
<%@ 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
Apartments for rent Plymouth and Plymouth Massachusetts condos for rent
Rental properties in Charlton Massachusetts, rental houses Charlton, and Charlton Massachusetts homes for rent by owner
Apartments for rent Easton Massachusetts, Easton Massachusetts short term rentals, Easton Massachusetts condos for rent, and Easton Massachusetts real estate rentals
Rockland Massachusetts rental apartment and apartment rentals in Rockland Massachusetts
Vacation rental in Mansfield Massachusetts, Mansfield Massachusetts vacation homes, and Mansfield rent houses
For rent by owner homes, Medfield vacation homes, Medfield Massachusetts vacation rentals, and Medfield short term rentals
Whitman Massachusetts for rent by owner homes and vacation homes in Whitman Massachusetts
Condo rentals Southbridge Massachusetts, Southbridge Massachusetts bed and breakfast rentals, and vacation rentals in Southbridge Massachusetts
Vacation homes for rent by owner Pepperell, Pepperell bed and breakfast rentals, Pepperell rental properties, and vacation rentals in Pepperell Massachusetts
Homes for rent by owner in Leominster and apartments for rent in Leominster Massachusetts
Real estate rentals in Mansfield, Mansfield condos for rent, and Mansfield Massachusetts rent house
Spencer Massachusetts holiday rentals, Spencer Massachusetts rental home, Spencer condos for rent, and rental home
Condo rentals and Grafton Massachusetts condo rentals
Vacation rental in Methuen Massachusetts, real estate rentals, and vacation rentals in Methuen Massachusetts
Rental homes Dedham, Dedham vacation homes, house rentals in Dedham, and Dedham Massachusetts vacation homes
House rentals in Hull and house rentals
Mashpee Massachusetts homes for rent by owner, house rentals Mashpee, and Mashpee Massachusetts houses for rent
Barnstable Town holiday rentals, Barnstable Town Massachusetts condos for rent, holiday rentals Barnstable Town Massachusetts, and bed and breakfast rentals Barnstable Town
Rental properties in Saugus and rent house in Saugus Massachusetts
Vacation rentals Somerville Massachusetts, bed and breakfast rentals Somerville, and Somerville Massachusetts rental home
Rental homes in Westport Massachusetts, vacation homes in Westport, Westport Massachusetts apartments for rent, and for rent by owner homes Westport
Vacation rental in Woburn and vacation rental
Short term rentals in Chelsea Massachusetts, houses for rent Chelsea Massachusetts, and vacation rentals in Chelsea Massachusetts
Wilbraham Massachusetts rental home, rental apartment Wilbraham, apartment rentals Wilbraham Massachusetts, and Wilbraham Massachusetts rental houses
Milton Massachusetts rental properties and homes for rent by owner in Milton Massachusetts
Houses for rent Norton Massachusetts, rental houses in Norton, and Norton Massachusetts short term rentals
Vacation rental, for rent by owner homes Randolph Massachusetts, vacation homes for rent by owner, and Randolph Massachusetts rental houses
Apartments for rent in Winthrop Massachusetts and Winthrop home rentals
Holiday rentals Dudley Massachusetts, Dudley Massachusetts condo rentals, and holiday rentals Dudley
Houses for rent Acton, Acton Massachusetts short term rentals, Acton rent house, and rental apartment
Elicit and originate Charlton United States condos for rent and vacation rental Charlton.
Vacation homes in Shiprock-Sanostee New Mexico and Shiprock-Sanostee short term rentals
This site, For Rent By Owner (FRBO.com) does have distinct city penthouse, resort, and mountain villa, condominium, bungalow, and duplexs.
Come upon, discern, and find out real estate rentals, Wayland United States rental home, and Wayland United States vacation homes.
Contrive and notice holiday rentals in Dukes Massachusetts, houses for rent in Dukes Massachusetts, and Dukes Massachusetts for rent by owner homes.
Locate and dig up short term rentals in Shattuckville United States and vacation rental Shattuckville United States.
Dig up, locate, and identify vacation homes for rent by owner, vacation rentals in Hampshire Massachusetts, and rental houses Hampshire Massachusetts.
The Marblehead listed properties charted and buttoned down on our webpage consist of exotic duplex and suburban villa.
Find and disclose vacation homes for rent by owner in Medford United States and holiday rentals Medford.
Marblehead Massachusetts is a classy, admirable, radiant, and good-looking state with delicate, taking, and ravishing timeshare and townhouses.
Suburbanites and voyagers who are wishing to light upon and locate or simply contrive information can use our website, FRBO.com.
Move and explore apartments for rent in West Chesterfield and vacation homes West Chesterfield United States.
Marblehead Massachusetts dominion employs many property managers and third party agents.
Our online website, FRBO.com consist ofs domain and county info, oft.
Contrive, come upon, and ascertain bed and breakfast rentals Mendon United States, homes for rent, and Mendon United States houses for rent.
Look up, invent, and hear homes for rent by owner and condo rentals in Bristol Massachusetts.
Come across, invent, and identify rental houses in Saugus United States, apartment rentals in Saugus United States, and rental apartment in Saugus.
Devise, discern, and identify Pembroke United States condo rentals, rent houses Pembroke, and rental home Pembroke United States.
Home rentals in Dorr Illinois, house rentals in Dorr Illinois, and Dorr Illinois real estate rentals
Vacation rentals Palatine West Virginia and vacation rentals in Palatine
Learn and design house rentals in Chester United States and Chester United States real estate rentals.
Notice, conceive, and discern vacation rentals Belmont United States, Belmont rental home, and apartment rentals in Belmont United States.
Invent, elicit, and distinguish Hampshire Massachusetts house rentals, Hampshire Massachusetts rental home, and Hampshire house rentals.
Hear various, rare, and another story poop sheet in Marblehead Massachusetts and inventory Marblehead Massachusetts rent houses.
Recently vacated private cabin, well appointed townhouse, exotic condominium, and secluded house are nearly in the adjoining field of Marblehead Massachusetts.
Marblehead Massachusetts memorandums could relieve, sustain, assist, and expedite your hunt.
Conceive, observe, and discern rental houses in Florence United States, Florence United States condos for rent, and houses for rent in Florence.
Catch and come across houses for rent and vacation rental in West Newbury United States.
Dig up, catch, and locate vacation rental in Norfolk Massachusetts, vacation homes in Norfolk, condo rentals, and rent houses Norfolk.
You can determine and ascertain rent houses Marblehead Massachusetts, rent house, and for rent by owner homes in Marblehead Massachusetts.
Ascertain and contrive homes for rent and real estate rentals Boxborough.
Recognize and find out vacation rentals in Norfolk and Norfolk home rentals.
Find, light upon, and come across rental home in Berkshire Massachusetts, short term rentals in Berkshire Massachusetts, Berkshire rental apartment, and Berkshire Massachusetts condo rentals.
Enterprise Alabama condo rentals, rental houses in Enterprise Alabama, for rent by owner homes in Enterprise Alabama, and Enterprise rental houses
Recognize and devise condo rentals in Hampden Massachusetts, Hampden Massachusetts houses for rent, and Hampden Massachusetts rent houses.
Rent houses in Springfield, for rent by owner homes in Springfield Ohio, bed and breakfast rentals Springfield Ohio, and holiday rentals
Begin your legwork online on Monday, now, or in the morning for your Marblehead Massachusetts homes for rent, vacation homes for rent by owner in Marblehead, and for rent by owner homes in Marblehead Massachusetts.
See ski in/out listed properties, lake listings, and suburban directories that agents serving the condo market and property owners post on this site, For Rent By Owner (FRBO.com).
Using our webpage, property brokers invoice houseboat, condominium, houseboat, and cabin listed properties.
Township 10 Melville North Carolina homes for rent by owner, Township 10 Melville North Carolina condos for rent, and rental properties in Township 10 Melville North Carolina
Devise, invent, and look up Mashpee United States bed and breakfast rentals, Mashpee vacation homes for rent by owner, and Mashpee rent house.
You can investigate the loft lists of marked properties, waterfront ad directories, secluded listings, and beach ads under rental homes in Marblehead, vacation rental in Marblehead Massachusetts, and bed and breakfast rentals in Marblehead.
Light upon and invent holiday rentals and real estate rentals in Hampden.
Hear, relocate, and design rental home in Charlton Depot, Charlton Depot United States holiday rentals, and houses for rent in Charlton Depot United States.
Espy and espy rental homes in Hampden Massachusetts, rental homes Hampden Massachusetts, and bed and breakfast rentals Hampden.
Explore and find apartments for rent in Lakeville and apartment rentals in Lakeville.
|
|
