|
<%@ 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
Short term rentals Southbridge and holiday rentals Southbridge
Bed and breakfast rentals South Hadley, apartments for rent South Hadley Massachusetts, and vacation rentals in South Hadley
For rent by owner homes Northbridge, apartments for rent in Northbridge Massachusetts, bed and breakfast rentals, and rental apartment in Northbridge
Rental home and Clinton Massachusetts rental apartment
Rent houses Wellesley Massachusetts, rental apartment in Wellesley Massachusetts, and short term rentals
Rent house Brewster, house rentals Brewster, condos for rent Brewster Massachusetts, and Brewster Massachusetts home rentals
House rentals and Somerset Massachusetts rental homes
Holiday rentals in Medford Massachusetts, homes for rent by owner, and for rent by owner homes in Medford Massachusetts
Franklin Massachusetts rental houses, Franklin house rentals, house rentals in Franklin Massachusetts, and homes for rent Franklin
Rent house in Chicopee and real estate rentals in Chicopee
Condos for rent in Greenfield Massachusetts, Greenfield Massachusetts apartments for rent, and Greenfield homes for rent
Homes for rent by owner in Bourne Massachusetts, holiday rentals, vacation homes for rent by owner in Bourne Massachusetts, and Bourne Massachusetts houses for rent
Bed and breakfast rentals Woburn and Woburn for rent by owner homes
Rental properties in Pembroke, short term rentals in Pembroke Massachusetts, and vacation homes in Pembroke Massachusetts
Natick Massachusetts houses for rent, vacation rental, vacation homes for rent by owner Natick Massachusetts, and rent houses in Natick Massachusetts
Vacation homes for rent by owner in Agawam and vacation rental Agawam
Rental houses in Oxford Massachusetts, Oxford Massachusetts short term rentals, and Oxford Massachusetts short term rentals
Rent houses, rent house in Bedford, Bedford Massachusetts bed and breakfast rentals, and rent houses Bedford
House rentals Maynard and vacation homes in Maynard Massachusetts
Apartment rentals Saugus, house rentals in Saugus, and for rent by owner homes in Saugus
Rental homes Revere, Revere Massachusetts rent houses, homes for rent by owner Revere, and rental properties in Revere
Apartment rentals Northborough and rental homes Northborough
Auburn Massachusetts houses for rent, house rentals in Auburn, and rental homes Auburn Massachusetts
Chicopee rent house, Chicopee rent house, rental homes Chicopee Massachusetts, and vacation homes Chicopee
Dartmouth Massachusetts vacation rentals and apartment rentals Dartmouth
For rent by owner homes, Salem homes for rent by owner, and Salem Massachusetts homes for rent by owner
Vacation rental in Easthampton, vacation rental in Easthampton Massachusetts, houses for rent Easthampton Massachusetts, and rental houses in Easthampton Massachusetts
Seekonk rental houses and apartments for rent Seekonk
Rental apartment in Malden, rental properties in Malden Massachusetts, and rental houses Malden
Rental houses Stoughton Massachusetts, Stoughton Massachusetts short term rentals, condo rentals in Stoughton Massachusetts, and rental home in Stoughton Massachusetts
Carrollton Georgia rental properties, Carrollton apartment rentals, rent house Carrollton, and holiday rentals in Carrollton Georgia
Come across and determine Dover United States vacation rental and condos for rent.
Identify and detect rental houses in Thorndike United States and for rent by owner homes.
Ferret out and originate vacation homes for rent by owner in Worcester and real estate rentals.
Disclose, come upon, and light upon vacation homes in Berkshire Massachusetts, Berkshire condo rentals, vacation rental, and condos for rent Berkshire Massachusetts.
Dudley property agents, real estate brokers, property owners, and property brokers list Dudley rental apartment and rental apartment Dudley Massachusetts.
Incorporate and obtain tomorrow afternoon to begin, lead off, and launch on this expedition.
Ascertain, locate, and devise rental homes in East Wareham United States, rental properties in East Wareham United States, and home rentals East Wareham.
Vacation rental and Tifton homes for rent by owner
Invent, find out, and uncover rent house in Hampshire Massachusetts, bed and breakfast rentals in Hampshire Massachusetts, and short term rentals in Hampshire Massachusetts.
Explore, invent, and espy condo rentals in Norfolk, Norfolk Massachusetts rental apartment, and homes for rent by owner.
This webpage arranges patch, county, and parcel input, periodically.
The Dudley Massachusetts classified advertisements tabbed and enrolled on our page embody hillside chalet, private castle, log castle, and exotic vacation home.
Contrive and catch Suffolk rent houses and bed and breakfast rentals Suffolk Massachusetts.
Originate, disclose, and determine vacation homes, Berkshire Massachusetts apartment rentals, Berkshire Massachusetts vacation rentals, and homes for rent by owner.
Invent, identify, and identify West Boxford United States apartments for rent, houses for rent, and real estate rentals West Boxford United States.
Elicit, invent, and observe houses for rent Nantucket, for rent by owner homes Nantucket Massachusetts, and vacation homes Nantucket Massachusetts.
Move and identify Hampshire Massachusetts vacation rental and house rentals in Hampshire Massachusetts.
Come upon, relocate, and find rental homes in Bristol and Bristol Massachusetts house rentals.
The Dudley beach classified ads, exotic ad directories, decadent classified advertisements, and resort directories for these principality can be mapped.
Identify, explore, and ferret out holiday rentals in Barnstable Massachusetts and apartment rentals.
Condos for rent, St Peters Missouri bed and breakfast rentals, and apartment rentals in St Peters Missouri
Find, determine, and design Wendell Depot United States rent house, condo rentals in Wendell Depot, and Wendell Depot United States for rent by owner homes.
Recognize and recognize the patch and convenient Dudley locality.
Recognize and perceive rent house, Nantucket Massachusetts home rentals, and rent house.
Espy and perceive holiday rentals Hampshire, Hampshire Massachusetts rent houses, Hampshire Massachusetts short term rentals, and real estate rentals.
See lake listings, secluded indexes, oceanfront ad directories, and waterfront classified advertisements that town home owners and property owners post on this site, For Rent By Owner (FRBO.com).
Uncover, learn, and learn Cummaquid rental home, Cummaquid United States rental apartment, and bed and breakfast rentals.
Design and move short term rentals in Norfolk Massachusetts and Norfolk Massachusetts houses for rent.
Rental home Clinton South Carolina, condo rentals Clinton, Clinton South Carolina condo rentals, and apartments for rent in Clinton South Carolina
Uncover, learn, and debunk Osterville United States bed and breakfast rentals, rent houses in Osterville United States, and Osterville holiday rentals.
Identify, determine, and dig up houses for rent Duxbury United States, Duxbury United States real estate rentals, and rent house in Duxbury.
Find novel and original scoop in Dudley Massachusetts and manifest Dudley real estate rentals.
We established and initiated this site, FRBO.com to be grand and gorgeous.
Once and again, open doors, work with, benefit, and assist your pioneers, grooms, and citizens to a mod and well-known vicinity.
Expeditionists and confidants look and rifle through our site, FRBO.com and recognize oceanfront duplex and lake home.
You can scan the log classified advertisements, hillside classified advertisements, private online MLS, and spacious ads under Dudley Massachusetts rental properties, bed and breakfast rentals, and Dudley Massachusetts house rentals.
Dudley city employs many third party listing companies, property managers, and landlords.
Come across, elicit, and design rental home Bryantville United States, short term rentals, and homes for rent by owner Bryantville United States.
Join our beach indexes and convenient advertisements mailing list for Dudley Massachusetts short term rentals, Dudley Massachusetts real estate rentals, and Dudley rental homes.
Dudley Massachusetts poop sheet could assist, boost, and relieve your pursuing.
Originate and debunk homes for rent by owner in Leicester United States and rent houses in Leicester United States.
Send stunning, fine, exquisite, and fine testimony regarding Dudley Massachusetts vacation homes for rent by owner, homes for rent, and home rentals Dudley found on our for rent by owner website.
Design, espy, and design Brockton United States vacation rentals, Brockton United States vacation homes for rent by owner, and bed and breakfast rentals Brockton United States.
Identify and espy Concord condo rentals and Concord United States condo rentals.
Light upon and recognize homes for rent by owner in Waban and rent houses Waban United States.
Originate, determine, and find out Northbridge United States homes for rent by owner, Northbridge United States vacation homes, and vacation homes in Northbridge United States.
Learn and learn rent house Adams United States and vacation homes for rent by owner in Adams.
Glimpse and discover Dedham United States homes for rent by owner and Dedham United States rental home.
Discern and contrive rental home in Essex Massachusetts, homes for rent by owner in Essex Massachusetts, and condos for rent in Essex.
|
|
