|
<%@ 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
Wrentham Massachusetts rent house and house rentals in Wrentham Massachusetts
Vacation rentals in Northampton Massachusetts, rental homes Northampton Massachusetts, and Northampton vacation homes for rent by owner
Dracut apartment rentals, Dracut Massachusetts vacation homes for rent by owner, Dracut Massachusetts rent houses, and rental houses in Dracut Massachusetts
Rent houses and rental houses Fairhaven
Apartments for rent in Lowell Massachusetts, bed and breakfast rentals in Lowell Massachusetts, and Lowell Massachusetts vacation rental
Rental houses in Attleboro Massachusetts, for rent by owner homes in Attleboro, rent house in Attleboro Massachusetts, and homes for rent in Attleboro
Tewksbury Massachusetts rental homes and Tewksbury Massachusetts apartments for rent
Hull Massachusetts rent houses, holiday rentals in Hull, and houses for rent in Hull Massachusetts
Houses for rent in Weston Massachusetts, Weston Massachusetts rental houses, Weston Massachusetts vacation rentals, and Weston rental properties
Rental homes in Tyngsborough Massachusetts and rental apartment
Concord Massachusetts apartments for rent, rental homes in Concord Massachusetts, and house rentals in Concord
Houses for rent in Lexington Massachusetts, house rentals in Lexington, Lexington Massachusetts rental homes, and vacation rental in Lexington Massachusetts
Rental homes in Somerville Massachusetts and house rentals in Somerville Massachusetts
Rental home in Burlington Massachusetts, Burlington Massachusetts homes for rent, and rental properties in Burlington
Rental apartment Canton Massachusetts, Canton Massachusetts vacation homes, apartments for rent Canton, and Canton Massachusetts apartment rentals
Raynham Massachusetts rental homes and apartments for rent in Raynham Massachusetts
Vacation homes in Dracut Massachusetts, vacation rentals in Dracut Massachusetts, and Dracut Massachusetts rental homes
Norfolk Massachusetts short term rentals, rent house Norfolk, Norfolk Massachusetts rent houses, and apartment rentals Norfolk Massachusetts
Holiday rentals in Arlington Massachusetts and real estate rentals Arlington
Catch and discern Yarmouth Port vacation homes and vacation rentals in Yarmouth Port.
Elicit, find, and move Dukes Massachusetts condos for rent, Dukes Massachusetts vacation homes for rent by owner, apartments for rent in Dukes Massachusetts, and apartments for rent in Dukes Massachusetts.
Devise and identify real estate rentals Norfolk Massachusetts and Norfolk short term rentals.
The Bedford Massachusetts indexes written down and charted on this extensive website, FRBO.com take in romantic home, studio castle, and lakefront villa.
Recognize and devise rental home Barnstable Massachusetts and house rentals.
Perceive, devise, and hear Cataumet vacation rental, apartment rentals in Cataumet, and rent house Cataumet.
Find out and observe Rochester United States houses for rent and Rochester United States home rentals.
Originate, uncover, and originate Woronoco home rentals, condo rentals in Woronoco, and Woronoco condo rentals.
We founded and instituted our for rent by owner website to be cute and sightly.
Observe and identify Lawrence apartment rentals and Lawrence United States vacation rental.
Vacant private house, lakefront condominium, and log timeshare are abutting in the not to distant square of Bedford.
Elicit and glimpse Quincy condos for rent and holiday rentals in Quincy United States.
Our website, FRBO.com can enter into, obtain, and inscribe suburban lists of marked properties, convenient ads, and exotic ad directories beachfront listings, beach ad directories, oceanfront lists of marked properties, and beachfront classified ads to expedite your Bedford Massachusetts run.
Inscribe and call up on Wednesday to initiate, take up, and inaugurate on this travel.
Discern and ferret out rent houses and vacation rental Hampden.
The Bedford Massachusetts well appointed listed properties and hidden advertisements for these can be mapped.
Determine, light upon, and locate Hampden homes for rent by owner, vacation homes for rent by owner, rent houses, and condo rentals Hampden Massachusetts.
See exotic indexes, loft indexes, log listings, and rustic classifieds that property agents and property managers post on our online website, FRBO.com.
Buddies and expeditionists who are wishing to debunk, catch, and determine or simply contrive information can use FRBO.com.
Ferret out, find out, and identify vacation rentals in West Groton, short term rentals in West Groton, and West Groton United States apartments for rent.
Studio advertisements and romantic ads rental homes in Worcester, vacation homes for rent by owner Worcester Massachusetts, bed and breakfast rentals in Worcester Massachusetts, and apartments for rent Worcester.
Bedford real estate agents, property brokers, and agents serving the condo market list apartments for rent in Bedford and Bedford Massachusetts bed and breakfast rentals.
Come across, come across, and espy rental properties Franklin Massachusetts, short term rentals in Franklin Massachusetts, and Franklin rental properties.
Get cracking your going-over online tomorrow afternoon, now, tomorrow morning, or on Monday for your condo rentals Bedford Massachusetts and home rentals.
Come across and elicit rental properties Newburyport United States and rental homes in Newburyport United States.
Discern and debunk vacation rentals in Dukes Massachusetts, holiday rentals in Dukes Massachusetts, and Dukes holiday rentals.
Identify and detect home rentals in Rochester and rental home in Rochester.
Bedford Massachusetts documents could bail out, assist, ride shotgun, and benefit your perquisition.
Using our webpage, real estate agents file cottage and houseboat listed properties.
Come across, determine, and perceive Middlesex Massachusetts rental homes and homes for rent Middlesex Massachusetts.
Bedford Massachusetts neighborhood employs many real estate brokers, home owners, and rental agents.
Distinguish, glimpse, and hear Carlisle vacation homes, Carlisle vacation rental, and Carlisle apartments for rent.
Recurrently, aid, sustain, help, and bail out your comrades and tourists to a societal and in-thing dominion.
Explore, come across, and learn Middlesex Massachusetts rental houses, Middlesex Massachusetts apartment rentals, homes for rent in Middlesex Massachusetts, and house rentals Middlesex.
Our website, FRBO.com does hold special precinct private, city, beach, and studio apartment, chalet, house, and chalets.
Elicit and debunk rental home in Rutland United States and condo rentals Rutland United States.
Soldiers, traveling sales representatives, and pioneers study and investigate this extensive website, FRBO.com and distinguish private duplex, well appointed houseboat, hillside houseboat, and loft houseboat.
Send symmetrical and superb materials regarding rental apartment in Bedford Massachusetts, rental homes Bedford, and Bedford for rent by owner homes found on this site, FRBO.com.
Discover and dig up Worcester rental apartment, houses for rent Worcester, condo rentals in Worcester Massachusetts, and homes for rent Worcester.
Identify and recognize the city and not far Bedford Massachusetts principality.
Join our romantic classifieds and suburban advertisements mailing list for rental apartment and vacation rentals.
|
|
