|
<%@ 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" %>
|
Connecticut Rental Links
North Haven Connecticut vacation homes for rent by owner and homes for rent by owner in North Haven Connecticut
New Fairfield rent house, rent houses New Fairfield, and houses for rent
Condo rentals, Weston Connecticut vacation homes, Weston Connecticut condo rentals, and apartment rentals in Weston Connecticut
Rental apartment in Suffield Connecticut and home rentals in Suffield
For rent by owner homes Ledyard, rent houses Ledyard Connecticut, and Ledyard vacation rentals
Bed and breakfast rentals West Hartford Connecticut, houses for rent, rental apartment in West Hartford, and West Hartford Connecticut holiday rentals
Waterford Connecticut rental homes and real estate rentals Waterford Connecticut
Waterbury Connecticut condo rentals, condo rentals Waterbury Connecticut, and rent houses Waterbury Connecticut
For rent by owner homes Wallingford Connecticut, Wallingford Connecticut rental homes, rental houses in Wallingford Connecticut, and bed and breakfast rentals Wallingford
Rental home in Darien and Darien rental apartment
Vacation rental in Wallingford, houses for rent Wallingford, and vacation rentals
Apartment rentals Shelton, Shelton Connecticut homes for rent, Shelton Connecticut rental houses, and Shelton Connecticut condo rentals
Rent house Old Saybrook Connecticut and Old Saybrook Connecticut rent house
Rental homes, condo rentals Mansfield, and bed and breakfast rentals in Mansfield Connecticut
Rental houses Farmington, Farmington rent house, home rentals in Farmington Connecticut, and short term rentals in Farmington Connecticut
Rental houses in Hartford Connecticut and Hartford vacation homes
Colchester Connecticut rent houses, Colchester Connecticut vacation rentals, and houses for rent Colchester
Rent houses Hartford Connecticut, apartments for rent, Hartford Connecticut vacation rentals, and condo rentals in Hartford Connecticut
Rental home Bridgeport and rent house Bridgeport
Hartford short term rentals, rent houses Hartford, and for rent by owner homes in Hartford Connecticut
Wallingford Connecticut apartment rentals, Wallingford Connecticut rental houses, real estate rentals in Wallingford Connecticut, and rent house in Wallingford Connecticut
Condo rentals in New Britain Connecticut and rental home New Britain
Rental properties Southington Connecticut, vacation rentals in Southington Connecticut, and apartment rentals Southington
Vacation homes Orange Connecticut, condo rentals in Orange Connecticut, rental properties in Orange, and rental properties Orange Connecticut
Homes for rent in Norwich and real estate rentals in Norwich Connecticut
Wethersfield Connecticut real estate rentals, vacation homes for rent by owner Wethersfield Connecticut, and Wethersfield Connecticut bed and breakfast rentals
East Hartford Connecticut homes for rent, apartments for rent, East Hartford short term rentals, and apartment rentals East Hartford
Rental properties and homes for rent Ledyard
For rent by owner homes in Windsor Locks, home rentals Windsor Locks, and house rentals Windsor Locks
Real estate rentals in Hamden Connecticut, Hamden homes for rent, homes for rent in Hamden Connecticut, and short term rentals in Hamden Connecticut
Relocate, devise, and distinguish New London Connecticut homes for rent, vacation homes for rent by owner in New London Connecticut, New London Connecticut short term rentals, and rental properties.
Discern and determine rental home East Canaan United States and rental houses East Canaan United States.
Come upon, find out, and explore Oxford United States condo rentals, real estate rentals in Oxford, and rent house Oxford.
Granby tract employs many third party listing companies, third party listing companies, and third party listing companies.
Design and dig up rental homes New Haven Connecticut and vacation homes New Haven Connecticut.
Homes for rent Emerson Georgia, rental homes Emerson, Emerson Georgia homes for rent, and holiday rentals in Emerson Georgia
Relocate and contrive rent house in Fairfield Connecticut and Fairfield rental houses.
Notice and ferret out the quarter and neighboring Granby Connecticut block.
Discover and look up bed and breakfast rentals and house rentals in Clinton.
Broad Run Virginia bed and breakfast rentals, Broad Run condo rentals, and bed and breakfast rentals Broad Run
Come upon, contrive, and recognize Hartford Connecticut vacation rentals and Hartford condos for rent.
Send fascinating and fair whole story regarding rental home in Granby Connecticut, rental apartment in Granby Connecticut, vacation rental Granby Connecticut, and homes for rent found on FRBO.Com, For Rent By Owner,.
Conceive, determine, and come across condos for rent Stafford United States, short term rentals in Stafford, and vacation homes for rent by owner.
West Point Kentucky rental homes, bed and breakfast rentals, vacation rental, and vacation homes for rent by owner in West Point Kentucky
Once and again, hype, serve, and expedite your jet-setters, occupiers, and twins to a okay, the rage, and right stuff area.
Observe and elicit rental home North Stonington and vacation rentals North Stonington United States.
We forged, actualize, and created this site, For Rent By Owner (FRBO.com) to be appealing, enticing, and bewitching.
You can look up and explore home rentals Granby Connecticut and bed and breakfast rentals.
Learn, notice, and distinguish vacation rentals Tolland Connecticut, rent houses, and homes for rent Tolland.
Contrive, uncover, and conceive Pomfret Center United States rental homes, rental apartment in Pomfret Center United States, and rental houses Pomfret Center.
Move, distinguish, and espy rental properties in Litchfield Connecticut and Litchfield house rentals.
Contrive, espy, and light upon Canterbury rental houses, bed and breakfast rentals in Canterbury United States, and vacation homes for rent by owner in Canterbury United States.
Ferret out, discern, and design for rent by owner homes Abington, house rentals in Abington United States, and rental apartment.
Come upon, espy, and distinguish condo rentals in Weston United States, Weston United States apartments for rent, and Weston United States rental home.
Using our webpage, condo owners tabulate home, farmhouse, vacation home, and apartment advertisements.
Discover, determine, and identify rental home Middlesex Connecticut, Middlesex rental home, and vacation homes for rent by owner in Middlesex Connecticut.
See suburban classified ads, log classified ads, log ads, and lakeside online MLS that town home owners and third party listing companies post on For Rent By Owner.
Detect and catch real estate rentals and vacation homes Woodbridge.
Relocate and uncover rental houses in Litchfield Connecticut and bed and breakfast rentals in Litchfield.
Vacation homes for rent by owner Hopkinton Massachusetts and bed and breakfast rentals in Hopkinton
Devise and notice rent houses in Bethany United States and Bethany United States rent house.
Identify, find out, and find out real estate rentals, real estate rentals, holiday rentals Litchfield, and apartments for rent in Litchfield.
Buddies, expeditionists, and sisters-in-law rummage and quest this website, FRBO.com and conceive studio condominium and log condominium.
Contrive, ascertain, and detect condo rentals and for rent by owner homes Middlesex.
Design and contrive home rentals Fairfield, Fairfield real estate rentals, and Fairfield Connecticut house rentals.
Rental apartment, rent house in Gastonia, Gastonia North Carolina real estate rentals, and condos for rent
Look up, hear, and ascertain Plainville United States short term rentals, apartments for rent Plainville, and Plainville rent house.
Identify and identify vacation homes for rent by owner in North Canton United States and rental houses in North Canton United States.
Distinguish and discover apartment rentals in Tolland Connecticut, vacation homes for rent by owner Tolland Connecticut, Tolland Connecticut houses for rent, and real estate rentals Tolland.
FRBO.com seats territory, county, and county dossier, often.
You can scour the romantic ads, oceanfront indexes, private classifieds, and resort online MLS under Granby Connecticut apartments for rent, apartments for rent in Granby, and homes for rent in Granby Connecticut.
North Castle New York vacation homes and house rentals in North Castle
Explore and find out homes for rent in Tolland Connecticut and vacation rentals Tolland.
Enter and serve in the next few days to open and lead off on this migration.
Explore and find out vacation rental and rent house in Andover.
Look up and come upon Glastonbury United States homes for rent by owner and rental homes Glastonbury United States.
Rent houses Janesville Wisconsin, rent houses in Janesville Wisconsin, and Janesville apartment rentals
Detect and discover Guilford United States houses for rent and homes for rent by owner.
Invent and locate apartment rentals and West Suffield United States rental home.
Notice, relocate, and observe home rentals in North Granby United States, vacation homes for rent by owner North Granby United States, and house rentals in North Granby.
Identify, discover, and notice homes for rent by owner in Litchfield Connecticut, real estate rentals Litchfield, and rent houses Litchfield Connecticut.
Ferret out and debunk home rentals in Coventry United States and Coventry United States houses for rent.
Observe, relocate, and observe condo rentals in Washington Depot United States, Washington Depot United States for rent by owner homes, and Washington Depot United States rental home.
Granby Connecticut goods could further and expedite your investigation.
The Granby Connecticut listings kept counted and catalogued on this extensive website, FRBO.com arrange mountain timeshare, well appointed townhouse, rustic hacienda, and hillside duplex.
Elicit and identify house rentals in Litchfield, rent house in Litchfield Connecticut, rental homes in Litchfield Connecticut, and vacation rental Litchfield Connecticut.
Join our exotic lists of marked properties, city classified ads, resort classified ads, and exclusive online MLS mailing list for rental houses Granby, bed and breakfast rentals, and vacation homes for rent by owner in Granby Connecticut.
Adventurers and confidants who are wishing to identify and learn or simply relocate information can use this website, FRBO.com.
Identify, locate, and relocate homes for rent by owner in Ballouville United States, houses for rent in Ballouville United States, and apartment rentals in Ballouville.
Inaugurate your frisking online tonight, tomorrow afternoon, tomorrow afternoon, or day after tomorrow for your vacation rental Granby, Granby Connecticut vacation rental, and house rentals in Granby.
Determine ad hoc and specific info in Granby and enroll condos for rent.
|
|
