|
<%@ 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
Vacation homes for rent by owner and vacation homes for rent by owner in Ludlow
Rental properties in Bourne Massachusetts, holiday rentals in Bourne, and Bourne Massachusetts house rentals
Wareham Massachusetts houses for rent, rental homes Wareham Massachusetts, vacation homes in Wareham, and rent houses in Wareham Massachusetts
Homes for rent by owner in Revere and Revere rental houses
New Bedford Massachusetts apartment rentals, vacation rental in New Bedford Massachusetts, and New Bedford homes for rent by owner
Randolph Massachusetts for rent by owner homes, houses for rent in Randolph Massachusetts, Randolph rental homes, and vacation rentals in Randolph
Real estate rentals in Plymouth Massachusetts and homes for rent
Seekonk Massachusetts vacation homes, houses for rent in Seekonk Massachusetts, and Seekonk Massachusetts holiday rentals
Rental homes Brockton, home rentals in Brockton Massachusetts, Brockton real estate rentals, and Brockton Massachusetts real estate rentals
Condo rentals in Belmont Massachusetts and rental apartment in Belmont Massachusetts
Real estate rentals, Barnstable Town condos for rent, and Barnstable Town apartments for rent
Bed and breakfast rentals Saugus Massachusetts, apartment rentals in Saugus Massachusetts, apartments for rent Saugus, and Saugus Massachusetts vacation homes
Rental properties Barnstable Town Massachusetts and house rentals Barnstable Town Massachusetts
This website, FRBO.com can join up, call up, and sign on suburban ads, loft directories, oceanfront directories, and beachfront directories lakeside classified advertisements and log ad directories to hype your Sharon Massachusetts traveling.
Identify, design, and perceive vacation rental in Dartmouth United States, vacation homes for rent by owner, and apartments for rent Dartmouth United States.
We actualize and coined FRBO.Com, For Rent By Owner, to be fine, classy, and fine.
Distinguish, discover, and locate the territory and not faraway Sharon section.
Sharon property managers, brokers leasing foreclosures, real estate brokers, and rental agents list Sharon Massachusetts vacation rental and Sharon Massachusetts real estate rentals.
See private lists of marked properties, private indexes, and beach online MLS that property agents and property agents post on our for rent by owner site, FRBO.com.
The Sharon Massachusetts well appointed online MLS, lakefront directories, and convenient advertisements for these can be mapped.
Sharon Massachusetts scoop could do for, hype, work with, and boost your expedition.
You can invent and light upon homes for rent in Sharon Massachusetts, rental home Sharon Massachusetts, and Sharon Massachusetts bed and breakfast rentals.
Dig up and detect rental homes in Pinehurst United States and for rent by owner homes.
Light upon and design rental houses in Tewksbury and Tewksbury United States house rentals.
Determine and explore rent houses in Methuen United States and rent houses in Methuen.
Using this site, For Rent By Owner (FRBO.com), brokers leasing foreclosures detail flat, castle, home, and condominium classified advertisements.
Join our lake classifieds, well appointed indexes, and beach classifieds mailing list for rent house in Sharon Massachusetts and rent houses Sharon Massachusetts.
Traveling women, soldiers, and occupiers who are wishing to perceive, debunk, and learn or simply dig up information can use this site, For Rent By Owner (FRBO.com).
Observe, contrive, and locate Norfolk Massachusetts vacation homes, Norfolk Massachusetts homes for rent by owner, and home rentals in Norfolk Massachusetts.
Unoccupied beachfront home, studio bungalow, decadent townhouse, and hidden flat are handy in the next area of Sharon.
Contrive and contrive vacation homes for rent by owner and rent houses.
Discover and originate home rentals Berkshire and vacation rentals Berkshire Massachusetts.
Our for rent by owner website take ins county, sector, dominion, and kingdom dope, periodically.
Obtain, enter, sign on, and register now to inaugurate, initiate, and get going on this crossing.
Notice, catch, and contrive rental houses in Berkshire Massachusetts and vacation rental in Berkshire.
Open your witch hunt online tomorrow afternoon, next week, or day after tomorrow for your Sharon Massachusetts short term rentals and Sharon Massachusetts house rentals.
|
|
