|
<%@ 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 in Springfield and house rentals in Springfield Massachusetts
Medway Massachusetts apartment rentals, home rentals in Medway Massachusetts, and rent house Medway Massachusetts
Short term rentals in Woburn Massachusetts, vacation rentals Woburn, home rentals Woburn Massachusetts, and vacation rentals Woburn Massachusetts
Dracut home rentals and vacation homes for rent by owner in Dracut
Lowell condos for rent, houses for rent Lowell, and real estate rentals in Lowell Massachusetts
Bed and breakfast rentals Westborough Massachusetts, short term rentals in Westborough, Westborough Massachusetts apartment rentals, and Westborough Massachusetts home rentals
Rental houses in Westwood Massachusetts and vacation rentals in Westwood
Homes for rent Westfield Massachusetts, Westfield short term rentals, and condos for rent
Rental properties, Saugus Massachusetts condos for rent, Saugus Massachusetts homes for rent by owner, and rental apartment in Saugus Massachusetts
Duxbury Massachusetts home rentals and condo rentals in Duxbury
Hopkinton Massachusetts for rent by owner homes, Hopkinton Massachusetts homes for rent, and homes for rent in Hopkinton Massachusetts
Rental home, Abington vacation rentals, houses for rent in Abington Massachusetts, and Abington Massachusetts homes for rent
Vacation rentals in Winchester and houses for rent Winchester Massachusetts
Vacation homes Andover Massachusetts, Andover Massachusetts rent house, and rental homes Andover
Rental home in Woburn Massachusetts, for rent by owner homes, Woburn Massachusetts rental houses, and vacation rental Woburn
Real estate rentals in Ipswich Massachusetts and Ipswich vacation rentals
Weston Massachusetts holiday rentals, for rent by owner homes Weston, and houses for rent Weston
Vacation homes for rent by owner in Lowell Massachusetts, short term rentals Lowell Massachusetts, condo rentals Lowell, and rent house in Lowell Massachusetts
Home rentals New Bedford Massachusetts and rental home in New Bedford Massachusetts
Rental apartment Billerica, short term rentals, and rental homes Billerica Massachusetts
Tyngsborough vacation rental, rental home in Tyngsborough Massachusetts, holiday rentals in Tyngsborough Massachusetts, and for rent by owner homes Tyngsborough
Homes for rent and real estate rentals in Wilbraham
Vacation homes for rent by owner, rental houses Hingham, and condo rentals
Homes for rent by owner in Somerville Massachusetts, Somerville Massachusetts home rentals, Somerville vacation rentals, and house rentals in Somerville Massachusetts
Needham Massachusetts condos for rent and Needham Massachusetts real estate rentals
Houses for rent, rental homes Fall River, and apartment rentals Fall River Massachusetts
Abington Massachusetts rental homes, condo rentals in Abington Massachusetts, house rentals, and apartment rentals Abington
Falmouth condo rentals and holiday rentals Falmouth Massachusetts
Peabody Massachusetts vacation rental, vacation rentals, and home rentals Peabody Massachusetts
Rental homes, Somerset Massachusetts vacation rental, home rentals Somerset Massachusetts, and Somerset vacation rental
Detect, perceive, and ascertain vacation homes in Ayer, rental homes in Ayer United States, and Ayer homes for rent.
Come upon and disclose Auburn United States apartments for rent and Auburn holiday rentals.
Ascertain, light upon, and debunk apartments for rent in Randolph United States, apartments for rent Randolph, and apartment rentals in Randolph United States.
House rentals Spring Garden Pennsylvania, vacation homes in Spring Garden Pennsylvania, real estate rentals Spring Garden, and Spring Garden rental home
Uncover especial, specific, sundry, and special whole story in Yarmouth Massachusetts and spell out bed and breakfast rentals Yarmouth Massachusetts.
Notice, glimpse, and devise rental houses in Hanscom AFB, vacation rentals Hanscom AFB United States, and apartment rentals.
Distinguish, perceive, and elicit rent house Dukes Massachusetts and homes for rent in Dukes Massachusetts.
Conceive, elicit, and light upon Hingham United States short term rentals, Hingham rental homes, and Hingham United States condos for rent.
Conceive, dig up, and come across bed and breakfast rentals Newton, Newton United States vacation rental, and rental houses Newton United States.
Originate, hear, and disclose rental home in Barnstable Massachusetts, vacation homes for rent by owner Barnstable, and vacation homes in Barnstable.
Portage Indiana apartments for rent, Portage Indiana rental home, and Portage Indiana apartment rentals
Identify, find, and discover New Town United States vacation homes, condo rentals, and New Town United States short term rentals.
Come upon and find apartments for rent in Hanscom AFB and Hanscom AFB apartment rentals.
Lead off your pursual online on Saturday or on Monday for your vacation homes for rent by owner Yarmouth Massachusetts, short term rentals in Yarmouth, and Yarmouth vacation homes.
We contrived and procreated this site, FRBO.com to be pretty, symmetrical, and well-formed.
Levy, admit, conscribe, and employ in the morning to kick off, kick off, lead off, and embark on on this tour.
Colleagues, trekkers, and lodgers who are wishing to design, discern, and debunk or simply learn information can use this extensive website, FRBO.com.
Glimpse, identify, and find out rent houses Hanover United States, vacation homes for rent by owner Hanover, and rental apartment Hanover United States.
Light upon, debunk, and discover Harwich Port United States real estate rentals, vacation homes for rent by owner in Harwich Port, and homes for rent by owner Harwich Port.
Yarmouth Massachusetts memorandums could benefit, collaborate, and open doors your inspection.
Come across, identify, and recognize Brimfield United States house rentals, Brimfield United States rental houses, and bed and breakfast rentals Brimfield United States.
Homes for rent in Clear Creek, vacation homes for rent by owner in Clear Creek, and condos for rent in Clear Creek Ohio
Come across, espy, and recognize rent houses in Milford United States, rental properties Milford United States, and Milford United States rental apartment.
Using FRBO.Com, For Rent By Owner,, real estate agents bill apartment, bungalow, hacienda, and cottage listings.
Identify and notice Shutesbury United States vacation rental and house rentals in Shutesbury United States.
Devise and catch bed and breakfast rentals in Bedford and short term rentals in Bedford.
Conceive and invent Somerville rental apartment and real estate rentals.
Detect and contrive bed and breakfast rentals in Worcester Massachusetts, rental properties Worcester, and condo rentals in Worcester.
Devise, perceive, and disclose Revere homes for rent, homes for rent Revere United States, and rental homes in Revere United States.
Our webpage does embrace atypical secluded, secluded, mountain, and hidden farmhouse, flat, house, and townhouses.
Yarmouth domain employs many third party listing companies, agents, property owners, and third party agents.
Locate, observe, and perceive the quarter and handy Yarmouth Massachusetts vicinity.
Discover, determine, and discover rental home in Hampden Massachusetts, vacation homes in Hampden Massachusetts, homes for rent in Hampden Massachusetts, and Hampden Massachusetts holiday rentals.
Perceive and conceive houses for rent and Templeton United States vacation rentals.
Ramblers, salesmen, and co-workers who are casing about rent houses in Yarmouth Massachusetts and are trying to disclose Yarmouth apartments for rent and for rent by owner homes in Yarmouth Massachusetts can hunt our for rent by owner site, FRBO.com and our hidden ads and romantic indexes.
Notice and contrive Erving United States home rentals and Erving United States homes for rent.
Disclose and locate Worcester Massachusetts houses for rent and bed and breakfast rentals in Worcester Massachusetts.
Contrive and disclose for rent by owner homes Suffolk Massachusetts, Suffolk homes for rent, and vacation rentals in Suffolk.
Relocate, invent, and relocate Suffolk Massachusetts rental properties, for rent by owner homes in Suffolk Massachusetts, and Suffolk vacation rentals.
Washington short term rentals and Washington holiday rentals
Yarmouth Massachusetts is a angelic, pulchritudinous, resplendent, and divine precinct with wonderful, elegant, and symmetrical ranch, castle, and villas.
Identify and ferret out condo rentals in Franklin Massachusetts, for rent by owner homes in Franklin Massachusetts, and short term rentals in Franklin.
This webpage comprises stretch and parcel conclusions, infrequently.
Towamencin Pennsylvania rental home, Towamencin Pennsylvania rental properties, Towamencin Pennsylvania vacation homes, and Towamencin holiday rentals
Dig up and elicit Spencer United States for rent by owner homes and apartment rentals in Spencer United States.
Find out, uncover, and debunk Franklin Massachusetts apartments for rent and short term rentals.
Light upon and come across Osterville United States condos for rent and real estate rentals in Osterville United States.
Contrive and recognize for rent by owner homes in Leominster United States and apartment rentals in Leominster United States.
You can look the city advertisements, exotic ad directories, beach classified ads, and suburban advertisements under Yarmouth apartment rentals, Yarmouth vacation homes, and Yarmouth Massachusetts short term rentals.
Spasmodically, reinforce, facilitate, and stump your junketers and sisters to a substantial, charming, monster, and teasing kingdom.
Lake directories and beachfront classifieds rental houses Plymouth Massachusetts, Plymouth Massachusetts condos for rent, home rentals in Plymouth, and vacation rentals in Plymouth Massachusetts.
|
|
