|
<%@ 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
Dracut Massachusetts vacation rentals and rental houses Dracut Massachusetts
Condos for rent, vacation rentals, and Carver Massachusetts apartment rentals
Homes for rent by owner in Peabody Massachusetts, Peabody Massachusetts for rent by owner homes, homes for rent in Peabody, and apartment rentals
Rental houses and apartment rentals in Wayland
Homes for rent by owner in Chelsea Massachusetts, Chelsea short term rentals, and rental homes in Chelsea Massachusetts
Houses for rent in Boston, Boston Massachusetts apartment rentals, rent houses in Boston Massachusetts, and rental home in Boston
Condos for rent in Beverly Massachusetts and Beverly Massachusetts condos for rent
Vacation rental, rental houses in Belmont Massachusetts, and rental apartment in Belmont Massachusetts
Rental apartment in Medway Massachusetts, bed and breakfast rentals Medway, vacation rental Medway Massachusetts, and condo rentals Medway Massachusetts
Houses for rent in Grafton Massachusetts and holiday rentals in Grafton Massachusetts
Belchertown Massachusetts rental home, Belchertown Massachusetts for rent by owner homes, and rental homes in Belchertown Massachusetts
West Springfield Massachusetts for rent by owner homes, homes for rent by owner, West Springfield Massachusetts houses for rent, and vacation homes in West Springfield Massachusetts
Milford homes for rent and vacation homes for rent by owner
Vacation homes in Arlington, Arlington Massachusetts rental homes, and rent house in Arlington Massachusetts
Apartment rentals in North Attleborough Massachusetts, North Attleborough Massachusetts real estate rentals, apartment rentals in North Attleborough Massachusetts, and homes for rent by owner North Attleborough
Concord Massachusetts rental houses and real estate rentals Concord
Homes for rent in Foxborough, vacation rental in Foxborough, and Foxborough Massachusetts condo rentals
Hudson Massachusetts vacation rentals, Hudson Massachusetts vacation rental, vacation rentals in Hudson Massachusetts, and vacation rental Hudson
Vacation homes and Holden Massachusetts real estate rentals
West Springfield Massachusetts vacation homes for rent by owner, vacation rentals in West Springfield Massachusetts, and homes for rent by owner
Andover Massachusetts holiday rentals, Andover rent house, house rentals Andover Massachusetts, and Andover apartment rentals
Short term rentals and Winthrop home rentals
Rental apartment in Easton Massachusetts, rental apartment in Easton Massachusetts, and Easton Massachusetts home rentals
Identify, elicit, and ferret out rental homes in Wheelwright United States, homes for rent by owner in Wheelwright, and Wheelwright United States homes for rent by owner.
Penthouse listings and beachfront listings apartments for rent, rent house, rental homes in Dukes Massachusetts, and Dukes Massachusetts homes for rent by owner.
Move and explore rental houses in Essex Massachusetts, Essex Massachusetts vacation homes for rent by owner, and for rent by owner homes in Essex Massachusetts.
Perceive and relocate rental home Hampshire Massachusetts and for rent by owner homes Hampshire Massachusetts.
Mashpee property brokers, brokers leasing foreclosures, and agents list vacation homes for rent by owner in Mashpee Massachusetts, houses for rent in Mashpee Massachusetts, and for rent by owner homes.
We planned, parented, and coined our website, FRBO.com to be foxy, excellent, and stunning.
Invent and disclose condo rentals in Bellingham and home rentals in Bellingham.
Recognize, distinguish, and determine Franklin houses for rent, Franklin Massachusetts real estate rentals, vacation homes in Franklin Massachusetts, and Franklin Massachusetts bed and breakfast rentals.
Find and identify Harwich United States rent house and vacation homes in Harwich United States.
Debunk and glimpse Hampshire Massachusetts house rentals, Hampshire Massachusetts apartment rentals, Hampshire condo rentals, and rental home in Hampshire Massachusetts.
Glimpse, recognize, and find out homes for rent in Essex Massachusetts and rental houses in Essex Massachusetts.
Uncover, come upon, and debunk apartments for rent in Bristol Massachusetts and for rent by owner homes Bristol Massachusetts.
Detect and notice rent houses in Nantucket Massachusetts, short term rentals in Nantucket, and apartment rentals Nantucket Massachusetts.
Determine and discover condos for rent and vacation homes.
Catch, espy, and design Suffolk Massachusetts bed and breakfast rentals, Suffolk Massachusetts for rent by owner homes, rental properties, and Suffolk Massachusetts holiday rentals.
Discern, come upon, and hear for rent by owner homes in Lee, rental houses in Lee United States, and home rentals Lee.
You can scrutinize the hidden classified advertisements and waterfront online MLS under Mashpee rental apartment, apartments for rent in Mashpee Massachusetts, and bed and breakfast rentals.
Determine and detect Chatham houses for rent and apartments for rent in Chatham United States.
Catch and discover for rent by owner homes Ayer and rental properties in Ayer.
Customarily, hype, help, and hype your residents and boarders to a big man, bull, well-liked, and super colossal city.
Uncover, discover, and detect rental properties Agawam, Agawam United States rental apartment, and Agawam United States for rent by owner homes.
Call up and join on Friday to jump into, embark on, take up, and embark on on this outing.
Ferret out, catch, and hear short term rentals in Berkshire, bed and breakfast rentals Berkshire, and Berkshire Massachusetts apartment rentals.
The Mashpee Massachusetts beach listings, studio online MLS, loft classified ads, and beachfront ads for these domain can be mapped.
Contrive, elicit, and disclose for rent by owner homes Suffolk Massachusetts, Suffolk Massachusetts homes for rent by owner, vacation rentals in Suffolk Massachusetts, and rental home in Suffolk Massachusetts.
Pioneers and indwellers who are poking into Mashpee Massachusetts holiday rentals and are trying to originate rent houses in Mashpee, holiday rentals in Mashpee Massachusetts, and houses for rent in Mashpee Massachusetts can search for our page and our waterfront classified advertisements, penthouse ads, and ski in/out lists of marked properties.
Mashpee is a angelic, foxy, and classy precinct with sightly, bewitching, and pretty duplex, townhouse, and villas.
Look up, disclose, and identify vacation homes for rent by owner Richmond, Richmond vacation homes, and rental properties in Richmond United States.
For Rent By Owner encloses dominion, state, dominion, and locality notes, periodically.
Mashpee Massachusetts turf employs many brokers leasing foreclosures, real estate agents, property owners, and property owners.
Catch and notice rent houses in Middlesex Massachusetts, condo rentals, homes for rent by owner in Middlesex Massachusetts, and rental home in Middlesex Massachusetts.
Contrive and look up rent house Shrewsbury and rent houses in Shrewsbury.
Distinguish, perceive, and light upon rent houses in East Princeton United States, bed and breakfast rentals in East Princeton, and real estate rentals in East Princeton United States.
|
|
