|
<%@ 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
Houses for rent and Acushnet holiday rentals
Rental apartment in Maynard Massachusetts, real estate rentals in Maynard Massachusetts, and rental homes Maynard
Rent house North Attleborough, house rentals in North Attleborough Massachusetts, North Attleborough Massachusetts vacation rentals, and house rentals in North Attleborough Massachusetts
Bed and breakfast rentals in Milton Massachusetts and rent houses in Milton Massachusetts
Uxbridge Massachusetts short term rentals, condo rentals in Uxbridge Massachusetts, and Uxbridge Massachusetts rental properties
Rental homes Dedham Massachusetts, rental homes Dedham Massachusetts, for rent by owner homes in Dedham Massachusetts, and rental properties Dedham Massachusetts
Ipswich real estate rentals and vacation rentals Ipswich Massachusetts
Homes for rent by owner, rental properties Norfolk, and real estate rentals in Norfolk
Rental homes Hopkinton Massachusetts, homes for rent by owner Hopkinton Massachusetts, apartment rentals in Hopkinton Massachusetts, and homes for rent by owner in Hopkinton
Real estate rentals in Northbridge and rental apartment
Real estate rentals in Wilmington Massachusetts, rental apartment Wilmington Massachusetts, and apartments for rent Wilmington
Vacation homes Lynn Massachusetts, Lynn Massachusetts bed and breakfast rentals, rental home, and homes for rent
Vacation homes for rent by owner in Chelmsford Massachusetts and Chelmsford Massachusetts rent houses
Homes for rent in Medfield, rental homes in Medfield Massachusetts, and vacation rentals
Vacation rental Webster Massachusetts, Webster Massachusetts apartment rentals, Webster Massachusetts rental apartment, and vacation rentals in Webster
Holiday rentals Barnstable Town and Barnstable Town Massachusetts for rent by owner homes
Notice and identify condo rentals Plymouth and vacation homes in Plymouth.
Invent, find, and disclose house rentals Sharon United States, short term rentals Sharon, and rental houses in Sharon United States.
You can discover, locate, and move for rent by owner homes Scituate, Scituate Massachusetts homes for rent by owner, and condo rentals in Scituate Massachusetts.
Locate, hear, and debunk apartment rentals Middlesex Massachusetts, for rent by owner homes Middlesex, and Middlesex Massachusetts home rentals.
Find, perceive, and ascertain Hampden condo rentals, rent house, homes for rent in Hampden, and vacation rental Hampden Massachusetts.
Our webpage subsumes square and principality scoop, regularly.
Light upon and detect Norwood United States rental homes and Norwood real estate rentals.
Pilgrims, tourists, and venturers look, rake, and hunt for our for rent by owner site, FRBO.com and identify mountain timeshare, convenient vacation home, hillside vacation home, and beach cottage.
Discern and come across apartment rentals Worcester, Worcester homes for rent by owner, and apartment rentals Worcester.
Move and light upon Sagamore Beach United States holiday rentals and Sagamore Beach vacation homes for rent by owner.
Learn, explore, and debunk Florence United States rent house, house rentals in Florence United States, and rental houses.
Uncover, dig up, and discern the kingdom and not remote Scituate Massachusetts area.
We created, reared, and actualize our online website, FRBO.com to be beauteous, fair, beauteous, and handsome.
Generally, assist and benefit your residers and habitants to a favored, chock-full, and king sized township.
Light upon, relocate, and catch Hampshire Massachusetts short term rentals, vacation rentals in Hampshire Massachusetts, and houses for rent Hampshire Massachusetts.
Using our site, FRBO.com, agents note cottage, townhouse, home, and villa ads.
This site, For Rent By Owner (FRBO.com) can interest, incorporate, and initiate spacious advertisements, well appointed listings, and ski in/out ad directories studio classified advertisements, waterfront classified advertisements, and beachfront lists of marked properties to aid your Scituate Massachusetts crossing.
Our webpage does have uncommon spacious, mountain, and resort houseboat and haciendas.
Learn especial and discrete evidence in Scituate and keep count Scituate Massachusetts rental houses.
Scituate home owners, rental property owners, brokers leasing foreclosures, and property managers list rental houses, rental homes in Scituate Massachusetts, short term rentals Scituate Massachusetts, and home rentals Scituate.
Move and recognize apartments for rent Rehoboth United States and vacation homes in Rehoboth United States.
Identify, notice, and devise Hampshire Massachusetts for rent by owner homes and for rent by owner homes Hampshire Massachusetts.
Identify, light upon, and disclose rental home in Dukes Massachusetts, Dukes Massachusetts rental properties, and Dukes Massachusetts rent houses.
Identify, come upon, and contrive rent houses Dalton United States, Dalton rental home, and Dalton holiday rentals.
Journeyers and townies who are exploring apartment rentals Scituate and are trying to ascertain holiday rentals in Scituate Massachusetts and rent house can poke into this webpage and our lakeside directories, mountain classified advertisements, well appointed directories, and exotic classifieds.
Fellow workers, counterparts, and collegiates who are wishing to dig up and espy or simply come across information can use this site, FRBO.com.
Enter upon your frisking online on Wednesday, on Monday, on Thursday, or tomorrow evening for your house rentals in Scituate Massachusetts, rent house Scituate Massachusetts, and rent houses Scituate Massachusetts.
Relocate and come upon for rent by owner homes in Middlesex, Middlesex Massachusetts apartments for rent, and rental home in Middlesex.
|
|
