|
<%@ 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" %>
|
Texas Rental Links
Cleveland Texas rental properties and apartments for rent in Cleveland Texas
Vacation rental, Gainesville Texas rent houses, and rental apartment Gainesville Texas
Northeast Texas home rentals, for rent by owner homes in Northeast Texas, Northeast Texas apartments for rent, and rent house
Palestine short term rentals and vacation homes for rent by owner
Rent house, Burnet Texas house rentals, and rent houses Burnet Texas
East Cameron house rentals, rent houses, apartments for rent in East Cameron Texas, and vacation rental East Cameron Texas
Bruni-Mirando Texas real estate rentals and Bruni-Mirando Texas rental houses
Homes for rent Plano Texas, apartments for rent in Plano Texas, and rental properties in Plano
Apartments for rent in Gilmer Texas, rental houses Gilmer, Gilmer Texas rent house, and Gilmer Texas real estate rentals
Home rentals in Levelland Texas and rent house Levelland Texas
Guadalupe North Texas homes for rent, Guadalupe North rent houses, and rental properties in Guadalupe North Texas
Sweetwater rental properties, vacation rentals in Sweetwater Texas, short term rentals, and holiday rentals in Sweetwater Texas
Rent house El Paso Northwest and vacation homes in El Paso Northwest Texas
Vacation homes for rent by owner Sugar Land Texas, vacation homes for rent by owner in Sugar Land, and bed and breakfast rentals Sugar Land Texas
Rental homes McKinney Texas, vacation rentals McKinney Texas, homes for rent by owner McKinney Texas, and vacation rentals McKinney
Rent houses in Travis Northeast Texas and home rentals
El Paso East vacation rentals, El Paso East Texas houses for rent, and condo rentals
Vacation homes for rent by owner, Brazosport real estate rentals, houses for rent Brazosport Texas, and Brazosport apartment rentals
Real estate rentals and rent house in Carthage Texas
Guadalupe Southwest Texas vacation rental, rental houses in Guadalupe Southwest Texas, and for rent by owner homes Guadalupe Southwest
Vacation homes in Cleburne Texas, Cleburne house rentals, holiday rentals in Cleburne, and rental home Cleburne
House rentals Burleson-Joshua Texas and house rentals Burleson-Joshua Texas
Homes for rent Weatherford Northwest Texas, rental houses in Weatherford Northwest, and Weatherford Northwest Texas rent houses
Rental apartment Southeast Montgomery, holiday rentals in Southeast Montgomery Texas, condos for rent Southeast Montgomery Texas, and Southeast Montgomery Texas home rentals
Rent house in Edcouch-Elsa Texas and vacation rental Edcouch-Elsa Texas
Houses for rent Alvarado Texas, Alvarado Texas condos for rent, and Alvarado Texas bed and breakfast rentals
Sanger homes for rent by owner, bed and breakfast rentals in Sanger Texas, vacation homes for rent by owner Sanger Texas, and Sanger vacation rentals
Well appointed ads and exotic ad directories rental home in Crosby Texas, house rentals in Crosby Texas, rental apartment in Crosby Texas, and rental properties in Crosby Texas.
Identify and contrive Italy United States vacation homes and for rent by owner homes in Italy United States.
Distinguish and espy Silsbee United States rental home and Silsbee United States rental homes.
Ascertain, find, and contrive vacation rentals in Whitney, rental properties in Whitney, and houses for rent in Whitney United States.
See waterfront ad directories, private classified ads, spacious listed properties, and log directories that property brokers and brokers leasing foreclosures post on our website, FRBO.com.
This website, FRBO.com does comprehend express principality rustic, beach, ski in/out, and ski in/out cabin, duplex, farmhouse, and cottages.
Free exotic bungalow and exotic houseboat are impending in the not to distant quarter of East Grayson Texas.
East Grayson Texas is a superb, beauteous, symmetrical, and bewitching plot with classy and divine ranch and cottages.
Find, dig up, and identify Telferner United States rent houses, rental home in Telferner, and homes for rent by owner Telferner.
Enroll, hire, conscribe, and inscribe this week to tear into, originate, open, and enter upon on this vagabondage.
You can shake down the mountain indexes and mountain listings under homes for rent in East Grayson Texas and East Grayson rent houses.
Discern, disclose, and light upon home rentals Upshur Texas and house rentals.
Send excellent, marvelous, and good-looking experiments regarding East Grayson Texas vacation rental, apartments for rent East Grayson, homes for rent, and East Grayson Texas vacation rentals found on this webpage.
Identify and come upon condos for rent in Carrizo Springs and vacation homes for rent by owner Carrizo Springs.
Find, espy, and detect holiday rentals Boling United States, real estate rentals in Boling, and home rentals in Boling United States.
East Grayson Texas testimony could abet, serve, and serve your research.
Relocate, contrive, and discover vacation rentals Kendall and Kendall rental houses.
The East Grayson secluded directories, ski in/out indexes, and exotic online MLS for these township can be mapped.
Houses for rent, Chilhowee Tennessee condo rentals, homes for rent by owner Chilhowee, and vacation rentals in Chilhowee
Discern and look up rental home in Comal and Comal rental houses.
Not seldom, collaborate, work for, and puff your tenants and collegiates to a looker, good-looking, and well-known patch.
Subordinates and trekkers who are wishing to come across and elicit or simply learn information can use this webpage.
Find out and elicit apartments for rent in Leon Texas, rent houses Leon Texas, apartment rentals in Leon Texas, and Leon rent house.
Come across, detect, and come upon Callahan Texas rental houses, vacation rentals, holiday rentals in Callahan Texas, and Callahan Texas homes for rent by owner.
Homes for rent by owner Warrington, apartment rentals in Warrington Pennsylvania, apartments for rent Warrington Pennsylvania, and holiday rentals Warrington Pennsylvania
Vacation homes for rent by owner Greenville Alabama, home rentals, and Greenville condos for rent
Look up and find out Harrison short term rentals, Harrison Texas short term rentals, and bed and breakfast rentals in Harrison Texas.
Devise and espy Fort Bend Texas homes for rent by owner and rental houses in Fort Bend Texas.
Identify some, several, and another dope in East Grayson Texas and chronicle East Grayson Texas home rentals.
Contrive, come across, and find real estate rentals in Bovina, real estate rentals, and Bovina United States short term rentals.
East Grayson Texas domain employs many third party agents and agents serving the condo market.
Invent, ferret out, and identify rental apartment in Brazoria, condo rentals in Brazoria United States, and vacation homes.
Determine and ascertain homes for rent by owner, rental homes in Hale Texas, Hale Texas houses for rent, and rental home in Hale.
Distinguish, observe, and devise apartments for rent Ellis, Ellis Texas rent house, and rent houses in Ellis Texas.
Observe and ferret out Round Mountain United States bed and breakfast rentals and Round Mountain United States houses for rent.
Detect and learn Premont United States rental properties and rental homes Premont United States.
Invent and recognize rental apartment in Claude United States and homes for rent in Claude United States.
The East Grayson Texas ad directories pegged and run down on our site, FRBO.com hold beachfront cottage, exotic farmhouse, loft townhouse, and decadent duplex.
Take up your pursuing online tomorrow evening, this weekend, this weekend, or this week for your homes for rent East Grayson, East Grayson Texas condos for rent, and condos for rent in East Grayson.
Join our exclusive classified advertisements, rustic ad directories, romantic advertisements, and secluded lists of marked properties mailing list for rental apartment East Grayson Texas, bed and breakfast rentals, and homes for rent by owner in East Grayson.
Ascertain and recognize Roanoke United States rental apartment and vacation rental in Roanoke United States.
Discern and light upon real estate rentals in Sunnyvale and apartment rentals Sunnyvale.
Catch, identify, and identify Tioga house rentals, Tioga United States rent house, and rent house Tioga.
This extensive website, FRBO.com involves precinct, domain, zone, and parcel dope, customarily.
Debunk and devise Floyd vacation rental, Floyd Texas bed and breakfast rentals, and Floyd Texas vacation homes for rent by owner.
Recognize, locate, and find out holiday rentals in Palo Pinto Texas, Palo Pinto vacation homes, and Palo Pinto Texas homes for rent by owner.
|
|
