|
<%@ 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
Real estate rentals in Abington Massachusetts and vacation rental
Belchertown Massachusetts vacation homes for rent by owner, apartment rentals Belchertown, and vacation homes in Belchertown
Vacation rentals in Spencer Massachusetts, vacation homes Spencer, bed and breakfast rentals Spencer Massachusetts, and Spencer houses for rent
Swansea Massachusetts for rent by owner homes and vacation rental Swansea Massachusetts
Hudson Massachusetts for rent by owner homes, Hudson rental properties, and vacation homes for rent by owner in Hudson Massachusetts
Houses for rent in Uxbridge Massachusetts, condos for rent in Uxbridge, rental properties in Uxbridge Massachusetts, and vacation homes in Uxbridge Massachusetts
Home rentals in Millbury Massachusetts and Millbury Massachusetts rental properties
Vacation homes in Rehoboth, condo rentals in Rehoboth Massachusetts, and Rehoboth Massachusetts apartment rentals
Vacation rentals Pembroke, holiday rentals Pembroke Massachusetts, holiday rentals Pembroke, and condo rentals Pembroke
Ludlow Massachusetts vacation rentals and rent houses in Ludlow
Real estate rentals in Wilbraham, rental home, and house rentals in Wilbraham
Vacation homes for rent by owner Weymouth, homes for rent in Weymouth, holiday rentals, and rental apartment in Weymouth Massachusetts
Hingham houses for rent and vacation homes Hingham
Rental properties in Wareham Massachusetts, Wareham Massachusetts rental home, and short term rentals in Wareham Massachusetts
Rent houses in Holliston, rental homes Holliston Massachusetts, vacation rental Holliston Massachusetts, and Holliston Massachusetts holiday rentals
Homes for rent in Cambridge and rental properties Cambridge Massachusetts
Westfield Massachusetts holiday rentals, Westfield Massachusetts real estate rentals, and rental home in Westfield
Homes for rent in Wilmington, real estate rentals, Wilmington condo rentals, and condo rentals Wilmington
Rental houses in Whitman Massachusetts and condo rentals Whitman
Rent houses in Medford Massachusetts, short term rentals in Medford Massachusetts, and real estate rentals in Medford Massachusetts
Rent house Chelmsford Massachusetts, Chelmsford Massachusetts rental apartment, bed and breakfast rentals in Chelmsford, and house rentals Chelmsford
Bed and breakfast rentals and rental home New Bedford Massachusetts
Franklin Massachusetts vacation rentals, Franklin Massachusetts vacation homes for rent by owner, and Franklin bed and breakfast rentals
Rental properties Peabody Massachusetts, homes for rent in Peabody Massachusetts, rent houses in Peabody Massachusetts, and vacation homes Peabody Massachusetts
Rental homes and Lexington Massachusetts home rentals
Houses for rent Uxbridge, Uxbridge vacation homes, and homes for rent by owner
Home rentals Hull, vacation homes Hull Massachusetts, rent houses in Hull Massachusetts, and Hull bed and breakfast rentals
Winthrop rent house and rent houses in Winthrop
Dedham Massachusetts condos for rent, Dedham Massachusetts house rentals, and vacation rentals in Dedham Massachusetts
Tyngsborough Massachusetts rent house, house rentals Tyngsborough, vacation rental Tyngsborough Massachusetts, and for rent by owner homes Tyngsborough
House rentals in Holden and vacation rentals in Holden Massachusetts
Yarmouth rental home, homes for rent by owner in Yarmouth, and Yarmouth Massachusetts rental home
Perceive and ferret out West Barnstable United States for rent by owner homes and West Barnstable United States rent houses.
Elicit, distinguish, and invent homes for rent by owner Watertown United States, real estate rentals, and Watertown United States rent house.
Rental houses Martin, Martin Tennessee rental properties, holiday rentals in Martin Tennessee, and real estate rentals in Martin Tennessee
Dig up, catch, and explore rental home, Plymouth rental apartment, rental properties, and vacation homes in Plymouth Massachusetts.
Lead off your exploration online tonight or next weekend for your vacation rental, bed and breakfast rentals Marshfield, and apartments for rent.
Schoolmates and friends search for and cast about FRBO.com and originate city bungalow, ski in/out houseboat, convenient cottage, and lake vacation home.
Determine and relocate condos for rent in Franklin and houses for rent in Franklin Massachusetts.
Locate and contrive Monroe Bridge United States vacation rentals and Monroe Bridge condo rentals.
Join our loft ads, private listings, waterfront ads, and rustic directories mailing list for condo rentals Marshfield and vacation rental Marshfield.
Elicit, conceive, and originate Plymouth rental homes, rental homes in Plymouth Massachusetts, and Plymouth Massachusetts rent houses.
Originate and catch rental properties and rental homes Hampshire.
Move and perceive Woburn United States vacation homes and rental homes in Woburn United States.
Design and locate Linwood United States rent house and houses for rent in Linwood.
Invent, disclose, and conceive rental properties in Berlin, home rentals in Berlin, and vacation rentals Berlin United States.
Conceive, distinguish, and espy rent house in Worcester Massachusetts, Worcester Massachusetts rent house, holiday rentals in Worcester Massachusetts, and apartments for rent in Worcester.
Spacious classifieds and romantic lists of marked properties real estate rentals in Barnstable, Barnstable Massachusetts house rentals, apartment rentals Barnstable Massachusetts, and Barnstable Massachusetts vacation rentals.
Uncover, find out, and debunk Sagamore Beach houses for rent, vacation homes for rent by owner Sagamore Beach United States, and rent house Sagamore Beach United States.
Move and identify Fiskdale apartment rentals and rental apartment in Fiskdale United States.
You can design and identify rent houses in Marshfield Massachusetts and condo rentals Marshfield Massachusetts.
Ferret out, devise, and move Siasconset United States houses for rent, Siasconset United States rent houses, and rental houses in Siasconset.
Marshfield Massachusetts section employs many rental owners, real estate investors, land owners, and brokers leasing foreclosures.
Identify, contrive, and recognize rental apartment in Middleton, Middleton vacation homes, and Middleton holiday rentals.
Seafarers, spouses, and transmigrants who are inspecting apartment rentals in Marshfield Massachusetts and are trying to dig up vacation rentals in Marshfield and real estate rentals in Marshfield can examine our page and our studio advertisements, studio indexes, decadent ads, and city classified advertisements.
Rental home, for rent by owner homes in Westside Georgia, and Westside Georgia vacation homes
Identify, invent, and originate Hampshire Massachusetts home rentals, vacation homes for rent by owner in Hampshire, and house rentals in Hampshire Massachusetts.
Real estate rentals in Palatine West Virginia and bed and breakfast rentals Palatine
Espy, conceive, and notice Barnstable United States bed and breakfast rentals, short term rentals Barnstable, and rental houses in Barnstable United States.
Originate and invent Suffolk Massachusetts condo rentals, Suffolk Massachusetts short term rentals, and rental apartment.
Come upon and recognize rent house in Swansea and Swansea United States holiday rentals.
The Marshfield Massachusetts hillside lists of marked properties, secluded online MLS, beachfront classified advertisements, and hillside classified advertisements for these can be mapped.
Ever so often, plug and root for your teachers and educators to a now, hep, and prepossessing kingdom.
Rental properties in Frenchtown, Frenchtown Michigan apartment rentals, vacation homes Frenchtown Michigan, and Frenchtown Michigan condo rentals
Look up, notice, and relocate vacation rental Mattapoisett, Mattapoisett United States vacation homes for rent by owner, and rental apartment in Mattapoisett.
Determine and observe vacation homes for rent by owner Sheffield and bed and breakfast rentals.
Learn, hear, and distinguish home rentals in Nantucket Massachusetts, rental apartment in Nantucket Massachusetts, and Nantucket rental home.
Explore, discover, and come across rental homes and vacation homes for rent by owner.
Move and originate Nantucket Massachusetts rental homes, Nantucket Massachusetts condos for rent, for rent by owner homes Nantucket, and vacation rentals in Nantucket Massachusetts.
Marshfield third party listing companies, agents, property owners, and brokers leasing foreclosures list holiday rentals in Marshfield and for rent by owner homes Marshfield Massachusetts.
Marshfield Massachusetts is a divine and sightly turf with splendid, fascinating, appealing, and excellent duplex, flat, hacienda, and villas.
Using this site, For Rent By Owner (FRBO.com), brokers leasing foreclosures tick off ranch and chalet listings.
Conneaut Ohio apartment rentals, short term rentals in Conneaut, Conneaut Ohio rental home, and vacation rental Conneaut Ohio
Send dazzling and fascinating results regarding Marshfield Massachusetts house rentals, condo rentals in Marshfield Massachusetts, and rent houses in Marshfield Massachusetts found on our online website, FRBO.com.
Passengers and speculators who are wishing to detect, recognize, and notice or simply elicit information can use our website, FRBO.com.
Discover, come upon, and espy Northampton United States for rent by owner homes, vacation homes for rent by owner Northampton United States, and condo rentals Northampton United States.
Learn and detect home rentals and Fairhaven vacation rental.
|
|
