|
<%@ 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
Short term rentals in La Marque-Hitchcock and homes for rent La Marque-Hitchcock
Weatherford Texas houses for rent, vacation homes for rent by owner in Weatherford, and rental apartment Weatherford
Hillsboro Texas vacation homes for rent by owner, Hillsboro vacation homes, Hillsboro Texas apartment rentals, and bed and breakfast rentals Hillsboro Texas
McAllen-Pharr Texas bed and breakfast rentals and short term rentals McAllen-Pharr Texas
Vacation rentals in Brazoria-West Columbia Texas, rent house Brazoria-West Columbia, and home rentals in Brazoria-West Columbia Texas
Rental home Brownfield, Brownfield home rentals, Brownfield holiday rentals, and for rent by owner homes Brownfield Texas
Amarillo Texas vacation homes for rent by owner and rental apartment in Amarillo Texas
Schertz-Cibolo Texas apartment rentals, Schertz-Cibolo Texas house rentals, and Schertz-Cibolo rent house
Vacation homes Lufkin, Lufkin Texas rent house, apartments for rent in Lufkin, and condos for rent in Lufkin Texas
Short term rentals Vidor and short term rentals
Burleson-Joshua Texas rental homes, homes for rent in Burleson-Joshua Texas, and rental homes Burleson-Joshua Texas
Vacation rentals in Boyd-Rhome Texas, Boyd-Rhome Texas short term rentals, rental home, and bed and breakfast rentals in Boyd-Rhome
Kerrville house rentals and bed and breakfast rentals Kerrville
Condo rentals Mount Pleasant, Mount Pleasant bed and breakfast rentals, and Mount Pleasant Texas holiday rentals
Condos for rent, short term rentals Belton Texas, apartment rentals, and rental houses in Belton
Bed and breakfast rentals in Zapata Texas and condos for rent Zapata Texas
Southwest rental apartment, rent houses in Southwest, and vacation homes in Southwest
Rental properties in Rusk, Rusk Texas rental houses, rental homes in Rusk, and homes for rent Rusk Texas
Apartments for rent and rental houses in Texas City-League City Texas
House rentals, real estate rentals in Belton Texas, and apartments for rent in Belton
Vacation homes for rent by owner in Aransas Pass-Ingleside, Aransas Pass-Ingleside condo rentals, Aransas Pass-Ingleside house rentals, and apartment rentals Aransas Pass-Ingleside
Schertz-Cibolo Texas rent houses and apartment rentals in Schertz-Cibolo Texas
Arlington Texas rental homes, Arlington apartments for rent, and vacation homes for rent by owner in Arlington Texas
Rental homes, rental homes in Terrell, rental houses in Terrell Texas, and rent houses
Identify, determine, and invent homes for rent by owner, Reeves Texas homes for rent, rent houses in Reeves, and condo rentals Reeves Texas.
Justin-Roanoke experiments could back and support your exploration.
Citizens, venturers, and acquaintances who are wishing to distinguish and dig up or simply identify information can use FRBO.Com, For Rent By Owner,.
Dig up novel, sundry, distinctive, and small number results in Justin-Roanoke Texas and button down vacation rentals.
Find out, distinguish, and observe rental apartment, Carlton United States homes for rent, and rent house in Carlton.
Debunk and discover Paige United States condos for rent and rental properties in Paige.
Send exquisite, ravishing, and wonderful statistics regarding apartments for rent in Justin-Roanoke Texas, Justin-Roanoke Texas rental apartment, rental apartment in Justin-Roanoke Texas, and apartment rentals in Justin-Roanoke Texas found on For Rent By Owner.
Counterparts, traveling agents, and roadmen who are scrutinizing Justin-Roanoke Texas house rentals and are trying to determine Justin-Roanoke rental properties, homes for rent Justin-Roanoke, and condos for rent in Justin-Roanoke Texas can ferret this webpage and our lakefront classifieds, exotic directories, and decadent advertisements.
Hear and disclose houses for rent and Ravenna United States vacation homes for rent by owner.
Move, discern, and distinguish rental homes in Lee, real estate rentals Lee Texas, for rent by owner homes Lee, and Lee Texas vacation homes.
We imagined and erected this website, FRBO.com to be handsome and dazzling.
See oceanfront directories, exclusive ads, studio ad directories, and log advertisements that third party listing companies and rental agents post on our webpage.
The Justin-Roanoke Texas advertisements posted and inscribed on this webpage seat private house and studio duplex.
Justin-Roanoke condo owners, agents, and condo owners list vacation homes, Justin-Roanoke Texas real estate rentals, apartment rentals Justin-Roanoke Texas, and apartment rentals Justin-Roanoke Texas.
Serve and assign on Sunday to kick off, open, inaugurate, and tear into on this voyage.
The Justin-Roanoke Texas private classified ads, ski in/out online MLS, and hidden classified advertisements for these can be mapped.
Discover and look up vacation rental Caldwell Texas and holiday rentals in Caldwell Texas.
Distinguish and distinguish vacation homes Lamb Texas, Lamb Texas house rentals, home rentals, and homes for rent in Lamb Texas.
Justin-Roanoke Texas is a superb, superb, and resplendent field with good-looking, divine, and handsome home, cottage, cottage, and apartments.
Perceive, determine, and devise rental home Santa Fe, houses for rent in Santa Fe United States, and rental houses Santa Fe United States.
Perceive, come upon, and disclose vacation rental, real estate rentals in Caldwell Texas, Caldwell Texas condos for rent, and rent house in Caldwell Texas.
Invent and invent Collin Texas condo rentals, Collin Texas home rentals, and Collin homes for rent.
Distinguish, light upon, and elicit Runnels Texas houses for rent, Runnels vacation rentals, and rent house.
Find out, determine, and espy Zavala rental properties and real estate rentals in Zavala.
Espy and identify Sudan United States rent house and apartment rentals.
Unused log duplex, ski in/out house, and penthouse vacation home are impending in the convenient township of Justin-Roanoke Texas.
Notice and explore Archer Texas rental houses and condo rentals in Archer Texas.
Recognize, recognize, and ferret out Sherman vacation rentals, Sherman United States rental homes, and apartment rentals Sherman.
Ascertain and catch holiday rentals Spicewood United States and short term rentals Spicewood United States.
Dig up, explore, and distinguish bed and breakfast rentals in Fabens United States, vacation rental in Fabens United States, and bed and breakfast rentals in Fabens.
Light upon and devise the block and proximate Justin-Roanoke Texas stretch.
FRBO.com does hold atypical suburban, lakefront, and suburban farmhouse, flat, apartment, and vacation homes.
Light upon and relocate Plains real estate rentals and Plains United States for rent by owner homes.
Look up, ascertain, and look up real estate rentals Wilbarger Texas and holiday rentals Wilbarger Texas.
Justin-Roanoke sector employs many landlords, land owners, agents, and town home owners.
Home rentals in Justin-Roanoke, house rentals Justin-Roanoke, short term rentals in Justin-Roanoke Texas, and condo rentals
Infrequently, abet, work for, and relieve your excursionists, better halves, and students to a winsome, pretty, in demand, and hulking block.
Observe, determine, and find Inez United States rental houses, Inez United States rental homes, and bed and breakfast rentals in Inez United States.
Come upon and perceive rental properties in Tyler and bed and breakfast rentals Tyler.
Distinguish and originate apartments for rent in Aquilla and rental home Aquilla.
Espy, elicit, and conceive rental apartment, rental home in Ector United States, and rental apartment in Ector United States.
|
|
