Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)
Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)
Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)
Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)
Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)
Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)
Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)
Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)
Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)
Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)
Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)
Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)
Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)
Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)
Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)
Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)
Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)
Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)
Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)
Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)
Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)
Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)
Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)
Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)
Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)
Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)
Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)
Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)
Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)
Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)
Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)
Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)
Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)
Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)
Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)
Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)
Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)
Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)
Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)
Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)
Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)
Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)
Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)
Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)
Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)
Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)
Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)
Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)
Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)
Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Range varchar(255)' at line 1Error: ALTER TABLE propData2 ADD RangeType varchar(255)
Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)
Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)
Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)
Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)
Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)
Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)
Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)
Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)
Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)
Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)
Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)
Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)
Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)
Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)
Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)
Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)
Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-26T18:07:30.913' ,`MLSNumber` = '10522711' ,`ListAgentFullName` = 'Robert Moore' ,`ListOfficeName` = 'Perry Homes Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.403450' ,`Longitude` = '-95.504072' ,`PhotoCount` = '20' ,`PostalCode` = '77318' ,`RoomCount` = '8' ,`ListPrice` = '589900.00' ,`Status` = 'Active' ,`StreetName` = 'Carina Gaze' ,`StreetNumber` = '706' ,`StreetSuffix` = 'Court' ,`City` = 'Willis' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3118' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'PERRY HOMES NEW CONSTRUCTION! Home office with French doors frames the entry. Guest suite with a walk-in closet and a full bath. Media room with French doors. Kitchen features a large pantry, double wall oven, 5-burner gas cooktop and a large island with built-in seating space. Family room with a wall of windows and a wood mantel fireplace. Primary suite with 12-foot coffered ceilings. Double doors lead to primary bath with separate vanities, a garden tub, separate glass-enclosed shower, and two walk-in closets. Extended covered backyard patio. Mud room leads to Three-car garage.' ,`Acres` = '' ,`Area` = '39' ,`BuilderName` = 'PERRY HOMES' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 6 Block 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7723' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '995' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '56 - Willis' ,`SchoolElementary` = 'W. LLOYD MEADOR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WILLIS HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERT P. BRABHAM MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'The Woodlands Hills' ,`TaxAmount` = '' ,`TaxRate` = '3.28' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1669649781' WHERE `Matrix_Unique_ID` = '207860890' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-26T18:39:39.643' ,`MLSNumber` = '21855703' ,`ListAgentFullName` = 'Rebecca Thomas' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = 'Tiffany Mathis' ,`SellingOfficeName` = 'Keller Williams Elite' ,`Latitude` = '29.911441' ,`Longitude` = '-94.813167' ,`PhotoCount` = '36' ,`PostalCode` = '77535' ,`RoomCount` = '6' ,`ListPrice` = '380000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'County Road 417' ,`StreetNumber` = '689' ,`StreetSuffix` = '' ,`City` = 'Dayton' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2096' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'If you are looking for a little land & a waterfront home tucked away in Dayton, this one is for you. Enjoy the Gorgeous view of Champions Lake from this home nestled on 1.14 acres. This 3/2/2 custom built home is well kept with beautiful Brazilian wood floors and cedar beams. Sellers have recently added all new paint, custom cabinets and beautiful granite counters, brand new 4 ton AC, stainless appliances, dishwasher with french doors,and much more. Roof is approximately 2 years. Call for a tour today! They do not come any nicer than this home.' ,`Acres` = '1.14' ,`Area` = '52' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Dayton' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'WOODRIDGE PARK SOUTH, BLOCK 1, LOT 28, 29 (W/2), ACRES 1.14' ,`LotDesciption` = 'Subdivision Lot,Water View,Waterfront' ,`LotSize` = '49658' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '74 - Dayton' ,`SchoolElementary` = 'KIMMIE M. BROWN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DAYTON HIGH SCHOOL' ,`SchoolMiddle` = 'WOODROW WILSON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodridge Park South' ,`TaxAmount` = '4222' ,`TaxRate` = '1.7625' ,`WaterSewer` = 'Septic Tank,Water District' ,`YearBuilt` = '1991' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669649782' WHERE `Matrix_Unique_ID` = '209517352' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-26T17:07:41.570' ,`MLSNumber` = '90479856' ,`ListAgentFullName` = 'Jane Draughon' ,`ListOfficeName` = 'RE/MAX The Woodlands & Spring' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.147366' ,`Longitude` = '-95.478713' ,`PhotoCount` = '40' ,`PostalCode` = '77380' ,`RoomCount` = '10' ,`ListPrice` = '725000.00' ,`Status` = 'Active' ,`StreetName` = 'Timberwagon' ,`StreetNumber` = '10712' ,`StreetSuffix` = 'Circle' ,`City` = 'The Woodlands' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3887' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Unique updated French style home in the heart of The Woodlands. Exquisite finishes and architectural details throughout with beautiful double iron front doors. The raised grand entry descends to the family room, featuring a spectacular fireplace which extends to the ceiling, surrounded by tall, elegant arched windows. The home features double pane energy efficient Anderson windows throughout, gorgeous updated hardwood floors, and a huge workshop w/ A/C. The lifetime Mansard roof shakes, metal stair balusters, stainless steel appliances, custom cabinets and granite kitchen and bath countertops are a few of the upgrades. Game room could also be 2nd primary ensuite bedroom. The remodeled primary bath has a huge walk-in shower, custom cabinets with quartz countertops, and new fixtures, toilet & lighting. The downstairs primary bedroom, with it\'s own cozy fireplace, has a gorgeous view of the huge, picturesque backyard oasis with multi-level decking for relaxing under the canopy of trees.' ,`Acres` = '0.4886' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'The Woodlands' ,`HeatSystem` = 'Central Gas,Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'WDLNDS VIL GROGANS ML 06, BLOCK 6, LOT 20' ,`LotDesciption` = 'In Golf Course Community,Subdivision Lot,Wooded' ,`LotSize` = '21283' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Aluminum,Other' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'SAM HAILEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'THE WOODLANDS COLLEGE PARK HIGH SCHOOL' ,`SchoolMiddle` = 'KNOX JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'French' ,`Subdivision` = 'Wdlnds Village Grogans Ml 06' ,`TaxAmount` = '7924' ,`TaxRate` = '2.0469' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1979' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669649782' WHERE `Matrix_Unique_ID` = '211414642' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-26T17:16:40.703' ,`MLSNumber` = '95959520' ,`ListAgentFullName` = 'Yvette Monroy' ,`ListOfficeName` = 'CORCORAN FERESTER REALTY' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.188495' ,`Longitude` = '-95.695043' ,`PhotoCount` = '24' ,`PostalCode` = '77354' ,`RoomCount` = '2' ,`ListPrice` = '175000.00' ,`Status` = 'Active' ,`StreetName` = 'Pine Bark' ,`StreetNumber` = '36819' ,`StreetSuffix` = 'Lane' ,`City` = 'Magnolia' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '840' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to the Hazy Hollow subdivision - where you are embraced with ultimate tranquility and PRIVACY! This home sits on over HALF AN ACRE of UNRESTRICTED land with a number of UPGRADES and RENOVATIONS from top to bottom and front to back! Enjoy a recently UPDATED ROOF and FLOORING and NEW HVAC SYSTEM including DUCTS. Additional improvements include a 50 AMP RV hookup with water and septic connection, a SECOND DRIVEWAY, new AUTOMATIC GATE, and RAIN GUTTERS. Interior and exterior doors have been replaced as well as the front and back stairs. The KITCHEN has been RENOVATED with new COUNTERTOPS and OVER THE RANGE HOOD. Wonderful BATHROOM UPGRADES include a new shower, vanity, and sink for a modern farmhouse design. New main exterior ELECTRICAL PANEL. This property is UNRESTRICED with NO HOA and LOW TAXES! It is perfect for any additional improvements you desire, such as a large garage or workshop! VIRTUAL TOUR LINK AVAILABLE UNDER PHOTOS!' ,`Acres` = '0.53' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Magnolia/1488 West' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'HAZY HOLLOW EAST EST 07, BLOCK 45, LOT 14, MH SERIAL # 0471,' ,`LotDesciption` = 'Cleared,Subdivision Lot,Wooded' ,`LotSize` = '23087' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'WILLIE E. WILLIAMS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA WEST HIGH SCHOOL' ,`SchoolMiddle` = 'MAGNOLIA JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Right Side,Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Hazy Hollow East Estate 07' ,`TaxAmount` = '985' ,`TaxRate` = '1.8587' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '1983' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1669649782' WHERE `Matrix_Unique_ID` = '211594929' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-26T18:06:08.597' ,`MLSNumber` = '74196079' ,`ListAgentFullName` = 'Jackie Murray' ,`ListOfficeName` = 'Weichert,REALTORS-Murray Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.671135' ,`Longitude` = '-95.518713' ,`PhotoCount` = '38' ,`PostalCode` = '77071' ,`RoomCount` = '10' ,`ListPrice` = '279900.00' ,`Status` = 'Active' ,`StreetName` = 'Murray Brook' ,`StreetNumber` = '10002' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2316' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEVER FLOODED! Charming original\nOwner home with spacious 4 bedroom 2.5 bath located inside the Braeburn Valley subdivision. Entry opens to spacious formal living and dining room with easy access to kitchen. Kitchen features ample counter and cabinet space with island, double ovens , overlooking breakfast room. Large Den features vaulted beamed ceiling, cozy fireplace and wall of windows!Plantation shutters! Primary bedroom with two closets and bathroom with shower. Generous size secondary bedrooms! Large utility room inside home with half bath. Nice size back yard and patio for entertaining. 2 car garage with additional 2 car carport. Easy access to H59, Beltway 8/ Sam Houston.Ready for new owners to put their own touches to make this their home! ' ,`Acres` = '0.1975' ,`Area` = '20' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Brays Oaks' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 15 BLK 5 BRAEBURN VALLEY SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8603' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'MILNE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SHARPSTOWN HIGH SCHOOL' ,`SchoolMiddle` = 'WELCH MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Braeburn Valley Sec 03' ,`TaxAmount` = '5873' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1968' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669649782' WHERE `Matrix_Unique_ID` = '211980776' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-26T18:57:39.007' ,`MLSNumber` = '26688632' ,`ListAgentFullName` = 'Garelyn Sauls' ,`ListOfficeName` = 'Nexthome Elite Advisors' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.642081' ,`Longitude` = '-95.398348' ,`PhotoCount` = '30' ,`PostalCode` = '77051' ,`RoomCount` = '9' ,`ListPrice` = '460000.00' ,`Status` = 'Active' ,`StreetName` = 'Eastgrove Park' ,`StreetNumber` = '11917' ,`StreetSuffix` = 'Way' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2658' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Kirby Landing is a privately gated community with easy access to HWY 288 and conveniently located only minutes from Downtown Houston and The Medical Center. Amenities include a centralized walking trail and a gated fun area for your four legged friends. This home offers a spacious open concept design, with a Rain Soft Water System & engineered wood flooring. This stunning home has a grand entry that leads you into the extended foyer with a valet, home office, a spacious bedroom and a full bath. The living area with a gourmet kitchen, seamless backsplash and spacious island, flows into the family room. Third floor has an oversized owner\'s suite and walk-in closet with dual vanity sinks, separate tub and shower in owner\'s bath & one secondary bedroom with en-suite bath. Some furniture pieces are available for sale or can be included in your offer. See attached Furniture List for more details.' ,`Acres` = '0.0726' ,`Area` = '3' ,`BuilderName` = 'K. Hovnanian Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Five Corners' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 6 BLK 2 KIRBY LANDING' ,`LotDesciption` = 'Corner' ,`LotSize` = '3161' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'REYNOLDS ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WORTHING HIGH SCHOOL' ,`SchoolMiddle` = 'ATTUCKS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Kirby Lndg' ,`TaxAmount` = '1165' ,`TaxRate` = '3.1919' ,`WaterSewer` = 'Other Water/Sewer,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669649783' WHERE `Matrix_Unique_ID` = '212281912' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-26T17:14:11.870' ,`MLSNumber` = '79184966' ,`ListAgentFullName` = 'Christine Luong' ,`ListOfficeName` = 'Realty USA' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.567580' ,`Longitude` = '-95.530190' ,`PhotoCount` = '19' ,`PostalCode` = '77459' ,`RoomCount` = '8' ,`ListPrice` = '325000.00' ,`Status` = 'Active' ,`StreetName` = 'Mission Valley' ,`StreetNumber` = '3715' ,`StreetSuffix` = 'Drive' ,`City` = 'Missouri City' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2573' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful spacious home located in a desirable master planned neighborhood with golf course. Home features granite counter tops, undermount sink, an island in the kitchen. Wood, tiles, and laminate thru out except for the 3 bedrooms upstairs but has with built ins in 2 of them. Master down with great size closet, and huge gameroom up. Decent sized backyard with a storage shed, and so much more, too much to list. Home is tenant occupied, tenant has been there for more than 6 years and would like to renew, advance notice needed, contact your agent and schedule your showing today, you will not be disappointed!' ,`Acres` = '' ,`Area` = '38' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Missouri City Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'QUAIL VALLEY GLENN LAKES SEC 3, BLOCK 1, LOT 55' ,`LotDesciption` = 'In Golf Course Community,Subdivision Lot' ,`LotSize` = '7876' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'LANTERN LANE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ELKINS HIGH SCHOOL' ,`SchoolMiddle` = 'QUAIL VALLEY MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Quail Valley Glenn Lakes Sec' ,`TaxAmount` = '5230' ,`TaxRate` = '2.50665' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1994' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669649783' WHERE `Matrix_Unique_ID` = '212668666' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-26T18:45:29.930' ,`MLSNumber` = '86595008' ,`ListAgentFullName` = 'David Edgerton' ,`ListOfficeName` = 'All City Real Estate, Ltd. Co.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.816208' ,`Longitude` = '-95.418562' ,`PhotoCount` = '39' ,`PostalCode` = '77018' ,`RoomCount` = '10' ,`ListPrice` = '839000.00' ,`Status` = 'Active' ,`StreetName` = 'Gardendale' ,`StreetNumber` = '1015' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3801' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Completely updated, now offering the size and space to meet a variety of needs, this home features 5 bedrooms, 4.5 baths, private study, upstairs game room, and an open concept living and kitchen area. Total transformation and extensive renovation in 2020, with luxury finishes providing a contemporary look and feel, along with energy efficient spray foam insulation to the entire envelope of home. Notable is the two primary bedroom suites (one up and one down), perfect for extended family or guests. Gorgeous kitchen with plenty of counter/cabinet space, sleek modern bathrooms, and huge closets. Enjoy fresh air with two 2nd floor balconies, or the covered backyard patio. Large backyard with direct access to the easement for added space and privacy. Everything you see is new, including windows, HCAV, floors, roof, electrical, lights, fixtures, and so much more. Not in a flood zone, low taxes, and no HOA. Located in Garden Oaks/Oak Forest area with nearby shopping and restaurants.' ,`Acres` = '0.1532' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Oak Forest East Area' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'TRS 7 & 8A BLK 1 SUNNY HOLLOW' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6675' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'GARDEN OAKS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALTRIP HIGH SCHOOL' ,`SchoolMiddle` = 'BLACK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sunny Hollow' ,`TaxAmount` = '10596' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1960' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669649783' WHERE `Matrix_Unique_ID` = '212689181' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-26T17:07:41.570' ,`MLSNumber` = '19359422' ,`ListAgentFullName` = 'Chris Wooldridge' ,`ListOfficeName` = 'Chris Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.741717' ,`Longitude` = '-95.596226' ,`PhotoCount` = '48' ,`PostalCode` = '77077' ,`RoomCount` = '7' ,`ListPrice` = '470000.00' ,`Status` = 'Active' ,`StreetName` = 'Olympia' ,`StreetNumber` = '12135' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2289' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Resort style living in the energy corridor! Wonderfully updated corner lot, one story brick home in Shadowbriar. Enter into the open living area with high ceilings and plank tile floor throughout. New windows in every room let the light in. New ceramic countertops, tile backsplash, stainless steel appliances and commercial grade gas range accent the island kitchen that begs for entertaining! Three secondary bedrooms, laundry and half bath are easily accessed. Primary suite features an oversize bedroom and resort style bath and spacious closets. Fresh neutral colors and finishes, abundant storage and attached garage. New HVAC, electrical panel and PEX piping. Large backyard with sprinkler system and concrete patio. Mature trees all around. Located just across the street from the neighborhood community center with pool and tennis courts. Zoned to acclaimed HISD schools. Terry Hershey Trail is nearby. Come and see this lovely home today! (*Buyer to verify all information)' ,`Acres` = '0.1979' ,`Area` = '31' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Energy Corridor' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 16 BLK 2 SHADOWBRIAR SEC 1' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '8624' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '580' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'ASHFORD/SHADOWBRIAR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WESTSIDE HIGH SCHOOL' ,`SchoolMiddle` = 'WEST BRIAR MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Shadowbriar' ,`TaxAmount` = '7482' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1981' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669649783' WHERE `Matrix_Unique_ID` = '212708300' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-26T17:24:36.180' ,`MLSNumber` = '58269698' ,`ListAgentFullName` = 'Desiree Harrod' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = 'Guillermo Orozco' ,`SellingOfficeName` = 'Realty ONE Group, Experience' ,`Latitude` = '30.253690' ,`Longitude` = '-95.518298' ,`PhotoCount` = '48' ,`PostalCode` = '77384' ,`RoomCount` = '5' ,`ListPrice` = '439000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Wallowa Ridge' ,`StreetNumber` = '14208' ,`StreetSuffix` = 'Lane' ,`City` = 'Conroe' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2700' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'If you are looking for a newer home near The Woodlands this four-bedroom, three-full bath is situated in Fosters Ridge. A short walk to the park, pool, and neighborhood lodge. Upon entering the home you are welcomed into a formal entry, office/study, and hallway to two of the secondary bedrooms. Along your journey to the kitchen you will find a gorgeous wood accent wall located in the Living Area, with a freestanding mock fireplace(Negotiable). This kitchen does not lack storage for the chef in your family. Kitchen overlooks the living and dinning area making entertaining a breeze. Right off the Living Area is another secondary bedroom with an en-suite bath. The primary is located in the back of the home and has picturesque windows over looking your private back yard. Primary bath is equipped with double sinks, vanity, separate shower, soaking tub and oversized walk in primary closest. Zoned to the highly sought after Woodlands Schools. Schedule your private tour!' ,`Acres` = '0.194' ,`Area` = '15' ,`BuilderName` = 'DR Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Mock Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Conroe Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S516406 - FOSTERS RIDGE 06, BLOCK 1, LOT 32, 50.000000% UDI' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8451' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '850' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'BUSH ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'THE WOODLANDS HIGH SCHOOL' ,`SchoolMiddle` = 'MCCULLOUGH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,No Photos/No Videos,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Fosters Ridge 06' ,`TaxAmount` = '4636' ,`TaxRate` = '3.1488' ,`WaterSewer` = 'Other Water/Sewer,Water District' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1669649783' WHERE `Matrix_Unique_ID` = '212708600' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-26T17:59:10.747' ,`MLSNumber` = '60767777' ,`ListAgentFullName` = 'Melissa Sanders' ,`ListOfficeName` = 'Coldwell Banker Realty, Cy-Fair Office' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.953694' ,`Longitude` = '-95.206484' ,`PhotoCount` = '26' ,`PostalCode` = '77346' ,`RoomCount` = '8' ,`ListPrice` = '375000.00' ,`Status` = 'Active' ,`StreetName` = 'Skene Bend' ,`StreetNumber` = '12203' ,`StreetSuffix` = 'Drive' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1882' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'You will fall in love from the moment you arrive! You are walking distance from the Blue Lagoon and your home upon entry will wrap its arms around you! With flooring throughout your high traffic areas and a total open concept for living it will welcome your family and friends for gatherings and family living. Your kitchen is upgraded throughout with GE Profile cooktop, double oven, microwave, Refrigerator and a farm sink with oversized Island. Your primary retreat welcomes you to relax and unwind with your oversized shower, dual vanity and a huge walk-in closet! Did I mention you can access your primary bedroom entering in through your utility room? You will fall in love with all Skene Bend has to offer you! Stop by today!' ,`Acres` = '0.1943' ,`Area` = '1' ,`BuilderName` = 'Shea Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Summerwood/Lakeshore' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 7 BLK 1 BALMORAL SEC 15' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8465' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1230' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'CENTENNIAL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SUMMER CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'AUTUMN RIDGE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Balmoral Sec 15' ,`TaxAmount` = '9921' ,`TaxRate` = '3.5573' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669649784' WHERE `Matrix_Unique_ID` = '212954930' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-26T17:07:41.570' ,`MLSNumber` = '92105862' ,`ListAgentFullName` = 'Lourdes Codina' ,`ListOfficeName` = 'Keller Williams Realty - Memor' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.827604' ,`Longitude` = '-95.730410' ,`PhotoCount` = '46' ,`PostalCode` = '77449' ,`RoomCount` = '5' ,`ListPrice` = '330000.00' ,`Status` = 'Active' ,`StreetName` = 'Cypress Rain' ,`StreetNumber` = '20731' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1510' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 2016, 3 Bedroom, 2 Bath Home, feels like new! Spacious Backyard and a covered and extended Patio. The Home\'s Facade is beautiful and welcoming. You will love the spacious kitchen with oversized granite Countertop. \r\nThe Refrigerator, Washer and Dryer, Freezer in the garage and Living Room Set can convey with the home. Don\'t miss this opportunity to own a home in the very desireable Raintree Village!' ,`Acres` = '0.132' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 8 BLK 3 RAINTREE VILLAGE SEC 13' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5751' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '436' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'FRANZ ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MORTON RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'MCDONALD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Raintree Village, Raintree Vlg' ,`TaxAmount` = '5072' ,`TaxRate` = '2.5633' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669649784' WHERE `Matrix_Unique_ID` = '212984635' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-26T18:14:54.503' ,`MLSNumber` = '45504635' ,`ListAgentFullName` = 'Madison Jones' ,`ListOfficeName` = 'Keller Williams Elite' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.789876' ,`Longitude` = '-95.198459' ,`PhotoCount` = '21' ,`PostalCode` = '77015' ,`RoomCount` = '4' ,`ListPrice` = '224000.00' ,`Status` = 'Active' ,`StreetName` = 'Chambly' ,`StreetNumber` = '502' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1530' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'WELCOME HOME!! 502 Chambly Dr is a STUNNING 4 bedroom 2 bath home that offers a spacious living room with a vaulted ceiling and beautiful fireplace, along with enough space for all family and friends! The kitchen includes all stainless appliances and opens up to both the dining and living room! Each bedroom has had new carpet put in as well as new ceiling fans installed. There is a new coat of paint inside and out of this home. The roof was REPLACED IN 2019!!! There is laminate flooring throughout the kitchen, dining, and living area with ceramic tile covering the hallway and bathrooms. The 2 car garage includes a new utility room (added on 10/6) coated with fresh paint. The back sliding glass doors lead out to a wonderful sized backyard with plenty of room to entertain. This massive 8,000 sqft lot is located in a cul de sac and is just minutes away from retail, restaurants, beltway 8 and I-10 freeway. Sold as-is. Refrigerator stays as well! Sellers are HIGHLY MOTIVATED!!' ,`Acres` = '0.1837' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'North Channel' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 22 BLK 5 RIVIERA EAST SEC 1 R/P' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '8000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '280' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '21 - Galena Park' ,`SchoolElementary` = 'NORMANDY CROSSING ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORTH SHORE SENIOR HIGH SCHOOL' ,`SchoolMiddle` = 'CUNNINGHAM MIDDLE SCHOOL (GALENA PARK)' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Riviera East Sec 01 R/P' ,`TaxAmount` = '3934' ,`TaxRate` = '2.6774' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669649784' WHERE `Matrix_Unique_ID` = '213018127' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-26T18:10:58.327' ,`MLSNumber` = '92670122' ,`ListAgentFullName` = 'Jerry Bredehoeft' ,`ListOfficeName` = 'Top Guns Realty on Lake Conroe' ,`SellingAgentFullName` = 'Holly Waldrum' ,`SellingOfficeName` = 'Keller Williams Advtge Realty' ,`Latitude` = '30.225991' ,`Longitude` = '-95.663672' ,`PhotoCount` = '50' ,`PostalCode` = '77354' ,`RoomCount` = '4' ,`ListPrice` = '416000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Winchester' ,`StreetNumber` = '12602' ,`StreetSuffix` = 'Court' ,`City` = 'Magnolia' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2232' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Open concept/split floor plan on almost 1 acre. Magnolia ISD.  New HVAC and roof in 2019.  New solid surface\r\nmaster shower in 2020. 12’ ceilings in main living areas and master bedroom.  9’ ceilings in\r\nbedrooms.  All bedrooms are oversize and have walk-in closets.  Fully finished oversize garage\r\n(22’x30’)/workshop (22’x10) with sink and rear garage door (bring your long bed truck or boat). \r\nDual washer and dryer hook-ups.  Wood burning stove in family room.  Commercial stove\r\nexhaust. Full brick exterior (including gables).  Low maintenance landscaping with mature oak\r\ntrees. Large and private backyard with vehicle/trailer/RV parking. Everything you can’t easily\r\nchange on a property, this property has correct.  House is move in ready and waiting to be\r\npersonalized by new owners. No MUD. Low taxes.' ,`Acres` = '0.907' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Magnolia/1488 East' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'MOSTYN MANOR 01, BLOCK 2, LOT 9, ACRES 0.910' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '39507' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'MAGNOLIA PARKWAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Mostyn Manor 01' ,`TaxAmount` = '5740' ,`TaxRate` = '1.8587' ,`WaterSewer` = 'Aerobic,Public Water' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669649784' WHERE `Matrix_Unique_ID` = '213161326' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-26T18:13:02.450' ,`MLSNumber` = '9026261' ,`ListAgentFullName` = 'Karen Sumner' ,`ListOfficeName` = 'Keller Williams Professionals' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.895056' ,`Longitude` = '-95.572131' ,`PhotoCount` = '49' ,`PostalCode` = '77040' ,`RoomCount` = '11' ,`ListPrice` = '545000.00' ,`Status` = 'Active' ,`StreetName` = 'Koester' ,`StreetNumber` = '16430' ,`StreetSuffix` = 'Street' ,`City` = 'Jersey Village' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '6' ,`SqFtTotal` = '4491' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'SUPER RARE 6 bedroom home, and the 700 Sq foot room with closet and full bathroom above the garage can be a 7TH bedroom or great gameroom, gym, separate office! All bedroom are large with spacious closets. Downstairs there is a large formal living room and formal dining room. Spacious family room open place to the island kitchen. Primary bedroom is downstairs, updated ensuite bathroom and his & her walk in closets. Double pane windows! Lovely swimming pool and plenty of play area. NO BACK NEIGHBORS! 3 CAR DETACHED OVERSIZED GARAGE. All of this in the lovely Country Club Estates section of Jersey Village. NO HOA!! NEVER FLOODED.' ,`Acres` = '0.3217' ,`Area` = '10' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Jersey Village' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 2 BLK 51 JERSEY VILLAGE COUNTRY CLUB ESTATES SEC 4' ,`LotDesciption` = 'Greenbelt,Subdivision Lot' ,`LotSize` = '14014' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'POST ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'JERSEY VILLAGE HIGH SCHOOL' ,`SchoolMiddle` = 'COOK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Jersey Village Country Club Estates' ,`TaxAmount` = '10409' ,`TaxRate` = '2.7758' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1990' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669649785' WHERE `Matrix_Unique_ID` = '213326600' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-26T17:18:08.547' ,`MLSNumber` = '55389867' ,`ListAgentFullName` = 'Joshua Garza' ,`ListOfficeName` = 'Apex Brokerage, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.278542' ,`Longitude` = '-94.829901' ,`PhotoCount` = '29' ,`PostalCode` = '77551' ,`RoomCount` = '2' ,`ListPrice` = '249990.00' ,`Status` = 'Active' ,`StreetName` = '59th' ,`StreetNumber` = '2122' ,`StreetSuffix` = 'Street' ,`City` = 'Galveston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1160' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A truly unique and rare find within walking distance to the beach ! This home has 2 bedrooms and 2 bathrooms with an additional flex room area perfect for bunk beds or an office. Entire Home has been refinished with high quality scratch resistant vinyl flooring, new appliances, new HVAC, and completely rewired. Plenty of retail shops and restaurants all within walking distance so grab this piece of paradise while you can and live on island time!' ,`Acres` = '0.0551' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures,Special Addendum' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Midtown - Galveston' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 121 HALL & JONES SUR LOT 1 TRACY SPECIAL SUB' ,`LotDesciption` = 'Corner,Other,Subdivision Lot' ,`LotSize` = '2400' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Other Style' ,`Subdivision` = 'Tracys' ,`TaxAmount` = '4451' ,`TaxRate` = '2.0662' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1970' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669649785' WHERE `Matrix_Unique_ID` = '213409200' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-26T17:51:41.840' ,`MLSNumber` = '11931724' ,`ListAgentFullName` = 'Robert Salmons' ,`ListOfficeName` = 'Entera Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.011279' ,`Longitude` = '-95.286864' ,`PhotoCount` = '28' ,`PostalCode` = '77338' ,`RoomCount` = '8' ,`ListPrice` = '249900.00' ,`Status` = 'Active' ,`StreetName` = 'Farm Ridge' ,`StreetNumber` = '9007' ,`StreetSuffix` = 'Lane' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1920' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Exciting 4 bedroom 2.5 bathroom home! Guests are greeted by charming curb appeal, and a covered front porch. The kitchen offers ample cabinet storage, and a breakfast area.' ,`Acres` = '0.1174' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure,Special Addendum' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Humble Area West' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 13 BLK 9 DEERBROOK ESTATES SEC 1 AMEND' ,`LotDesciption` = 'Other' ,`LotSize` = '5115' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'JONES ELEMENTARY SCHOOL (ALDINE)' ,`SchoolHigh` = 'NIMITZ HIGH SCHOOL (ALDINE)' ,`SchoolMiddle` = 'JONES MIDDLE SCHOOL (ALDINE)' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Deerbrook Estates' ,`TaxAmount` = '5068' ,`TaxRate` = '2.7433' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1669649785' WHERE `Matrix_Unique_ID` = '213427769' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-26T17:07:41.570' ,`MLSNumber` = '33863954' ,`ListAgentFullName` = 'Reno Dominguez' ,`ListOfficeName` = 'Keller Williams HoustonCentral' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.663842' ,`Longitude` = '-95.688929' ,`PhotoCount` = '37' ,`PostalCode` = '77407' ,`RoomCount` = '9' ,`ListPrice` = '549500.00' ,`Status` = 'Active' ,`StreetName` = 'Meadow Light' ,`StreetNumber` = '17315' ,`StreetSuffix` = 'Drive' ,`City` = 'Richmond' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3501' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This move in ready 5 Bedroom/3.5 bath in Aliana has everything you’re looking for. Living room features 2 story ceilings, lots of natural light, and electronic blinds. The open concept kitchen has an island, lots of counter and cabinet space, under cabinet lighting, and S/S appliances. Home also has smart phone connectivity allowing you to control the garage door opener, thermostat, front door lock, living room blinds, and some lighting. Upstairs you’ll find 2 full baths, 4 bedrooms, media room, and game room! The recently installed covered patio in the backyard is perfect for outdoor entertaining. Tons of storage space! New carpet installed 2020, roof replaced 2019, covered patio installed 2022. Minutes from Madden Elementary, Target, HEB, & Restaurants! Easy access to Westpark Tollway, 1464, and 99.' ,`Acres` = '0.1708' ,`Area` = '37' ,`BuilderName` = 'Plantation Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sugar Land West' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'ALIANA SEC 7, BLOCK 2, LOT 10' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7440' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1250' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'MADDEN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TRAVIS HIGH SCHOOL (FORT BEND)' ,`SchoolMiddle` = 'GARCIA MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Aliana Sec 7' ,`TaxAmount` = '10810' ,`TaxRate` = '2.9329' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '2012' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669649785' WHERE `Matrix_Unique_ID` = '213615286' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-26T17:08:12.673' ,`MLSNumber` = '66104846' ,`ListAgentFullName` = 'Kevin Baker' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.040434' ,`Longitude` = '-95.526964' ,`PhotoCount` = '35' ,`PostalCode` = '77379' ,`RoomCount` = '9' ,`ListPrice` = '470000.00' ,`Status` = 'Active' ,`StreetName` = 'River Rapids' ,`StreetNumber` = '7046' ,`StreetSuffix` = 'Lane' ,`City` = 'Spring' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '3332' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Large 5 bedroom home with rare oversized lot and expansive backyard in beautiful Twin Falls! One of the largest lots and backyards in the area, plus no neighbors in the back ever! Gorgeous 2 story 5 full Bedrooms/4 Full Bathrooms/2 Car Grg! No carpet down, new flooring throughout! New carpet upstairs! Game Room Up! Formal Dining Room! Lovely Kitchen w/Granite Countertops, 42\'\' Raised Panel Cabinets w/Crown Molding, fridge/washer/dryer. Master Suite w/Large W/I Closet! Fireplace!Covered Patio! Energy Efficient 16 SEER HVAC, sprinkler system & MORE! Great home in great location! Excellent community with walking paths and pool. Excellent Klein schools, Klein High School. Never flooded! check it out today' ,`Acres` = '0.284' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Champions Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 16 BLK 2 TWIN FALLS SEC 5' ,`LotDesciption` = 'Greenbelt,Subdivision Lot' ,`LotSize` = '12370' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'KUEHNLE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN HIGH SCHOOL' ,`SchoolMiddle` = 'KRIMMEL INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Twin Falls Sec 5' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669649786' WHERE `Matrix_Unique_ID` = '213666649' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-26T17:07:41.570' ,`MLSNumber` = '84868790' ,`ListAgentFullName` = 'Azalea Marquez' ,`ListOfficeName` = 'Texas Premier Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.921846' ,`Longitude` = '-95.579421' ,`PhotoCount` = '22' ,`PostalCode` = '77064' ,`RoomCount` = '8' ,`ListPrice` = '255900.00' ,`Status` = 'Active' ,`StreetName` = 'Autumn Meadow' ,`StreetNumber` = '10227' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1838' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful two story in White Oak Bend! 3 bedroom 2 full bath. Well kept and clean. Pretty flooring thru-out. Two living areas and high ceilings. Fireplace for cozy cooler weather. Covered patio for a patio table to enjoy the falling leaves. Must see.' ,`Acres` = '0.1446' ,`Area` = '10' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Willowbrook South' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 29 BLK 2 WHITE OAK BEND SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6300' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '320' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'BANG ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS RIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'CAMPBELL MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'White Oak Bend Sec 01' ,`TaxAmount` = '5371' ,`TaxRate` = '2.84' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1981' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669649786' WHERE `Matrix_Unique_ID` = '213858115' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-26T17:58:03.777' ,`MLSNumber` = '73605139' ,`ListAgentFullName` = 'Melissa Sanders' ,`ListOfficeName` = 'Coldwell Banker Realty, Cy-Fair Office' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.071485' ,`Longitude` = '-95.523113' ,`PhotoCount` = '12' ,`PostalCode` = '77379' ,`RoomCount` = '6' ,`ListPrice` = '250000.00' ,`Status` = 'Active' ,`StreetName` = 'Winter Mountain' ,`StreetNumber` = '6511' ,`StreetSuffix` = 'Lane' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1807' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Home in time for the holidays! Seller has had the home freshly painted from top to bottom even the garage! This home offers you a living space along with formal dining room, raised breakfast bar. Upstairs you will find a cute little game room or you can make it a sitting area. In the backyard you will find a nicely bricked patio area and a gorgeous hot tub. This home is move in ready! Did I mention that there is a water softening system as well?? Stop by and visit today!' ,`Acres` = '0.1263' ,`Area` = '14' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring/Klein/Tomball' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 2 BLK 4 SPRINGBROOK SEC 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '330' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'BENIGNUS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN OAK HIGH SCHOOL' ,`SchoolMiddle` = 'KRIMMEL INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Springbrook Sec 5' ,`TaxAmount` = '4635' ,`TaxRate` = '2.5965' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669649786' WHERE `Matrix_Unique_ID` = '213859355' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-26T17:37:31.727' ,`MLSNumber` = '94374265' ,`ListAgentFullName` = 'Pinky Pirani' ,`ListOfficeName` = 'Keller Williams Realty -SW' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.690261' ,`Longitude` = '-95.713818' ,`PhotoCount` = '49' ,`PostalCode` = '77407' ,`RoomCount` = '7' ,`ListPrice` = '350000.00' ,`Status` = 'Active' ,`StreetName` = 'Fulvetta Haven' ,`StreetNumber` = '19023' ,`StreetSuffix` = 'Way' ,`City` = 'Richmond' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1770' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Very well-maintained with tons of upgrades, this home is like brand-new and now ready for you! This home with lovely brick elevation is from Taylor Morrison’s top selling “Rosebay “plan which offers elegant living and optimal living space. It features 3 bedrooms, 2 full baths, study, and formal dining room. Fresh paint throughout, newly washed carpet, gems like stone studded back splash, upgraded countertops, cabinets, water softener, sophisticated wood flooring, French doors, garage door opener, long drive way and so much more! Blinds all over with lights and fans in all rooms, plus home comes with washer, dryer and refrigerator. Spacious backyard and covered patio perfect for outdoor activities. Nestled in Richmond’s top selling master planned community with low tax rates. Conveniently located close to Westpark tollway, Grand Park Way, Harlem and just a few minutes from Messina Winery. Zoned to Fort Bend ISD. Great home in a great location! Make this home yours now!' ,`Acres` = '0.1328' ,`Area` = '37' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Mission Bend Area' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'GRAND VISTA SEC 26, BLOCK 1, LOT 13' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5784' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Tile' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'PATTERSON ELEMENTARY SCHOOL (FORT BEND)' ,`SchoolHigh` = 'BUSH HIGH SCHOOL' ,`SchoolMiddle` = 'CROCKETT MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Grand Vista' ,`TaxAmount` = '5357' ,`TaxRate` = '2.4297' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669649786' WHERE `Matrix_Unique_ID` = '213902112' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-26T18:19:19.710' ,`MLSNumber` = '80245621' ,`ListAgentFullName` = 'Ebony Royal' ,`ListOfficeName` = 'Braden Real Estate Group, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.627801' ,`Longitude` = '-95.384113' ,`PhotoCount` = '22' ,`PostalCode` = '77047' ,`RoomCount` = '5' ,`ListPrice` = '298990.00' ,`Status` = 'Active' ,`StreetName` = 'Stamford Hill' ,`StreetNumber` = '2915' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1396' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'D.R. Horton is America\'s #1 Builder since 2002! Want to live the suburban life close Downtown Houston, The Medical Center, and NRG Stadium? You have found a highly sought after neighborhood that offers you modern designs at affordable pricing. Come out an see this NEW CONSTRUCTION Brooke plan with elevation M. \r\n\r\nThe OPEN CONCEPT design features 3 bedrooms, 2 baths, a beautiful kitchen that includes quartz countertops, 42\" inch cabinets, large bar area, and stainless steal appliances including gas free-standing range, built-in microwave, and dishwasher. Enjoy the oversized shower in the Primary Bath, along with a large walk-in closet. Water resistant vinyl flooring, 2\" blinds, and tankless water heater also included. In addition, enjoy Smart Home Animation. Don\'t pass up this opportunity, this will be one of the first homes in the new section of the community.\r\n*PHOTOS ARE NOT PICTURES OF THE ACTUAL HOME BUT ARE A REPRESENTATION*' ,`Acres` = '' ,`Area` = '3' ,`BuilderName` = 'D.R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Medical Center South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 7 Block 2 Section 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4920' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'LAW ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WORTHING HIGH SCHOOL' ,`SchoolMiddle` = 'THOMAS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'City Gate' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1669649786' WHERE `Matrix_Unique_ID` = '213992695' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-26T18:10:25.287' ,`MLSNumber` = '56305156' ,`ListAgentFullName` = 'Susan Garczynski' ,`ListOfficeName` = 'Keller Williams Realty -SW' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.039776' ,`Longitude` = '-95.462975' ,`PhotoCount` = '50' ,`PostalCode` = '77566' ,`RoomCount` = '9' ,`ListPrice` = '285000.00' ,`Status` = 'Active' ,`StreetName` = 'Plum' ,`StreetNumber` = '54' ,`StreetSuffix` = 'Court' ,`City` = 'Lake Jackson' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2180' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 4 Bedroom Home in the Heart of Lake Jackson! Recently updated with gorgeous flooring downstairs and an updated half bathroom too! Multiple Living Areas plus a Large Family Room that is open to the Kitchen and Breakfast Room. Kitchen has granite counters and an abundance of cabinet and counter space. The Primary Suite is a Must See! The Bedroom is Large and the Bathroom has double sinks plus a separate shower and large jetted tub! This Fabulous Home is located on a Huge Lot on a cul-de-sac street. It has an oversized Screened in Porch in the backyard with mature trees. Another exciting plus about this property is the extended driveway that allows for multiple vehicles to be parked. Contact your Agent today for a showing! This Beauty will sell fast!' ,`Acres` = '0.2123' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Jackson' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'PLANTATION VILLAGE SEC 9 (LAKE JACKSON), BLOCK 3, LOT 40' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9248' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '7 - Brazosport' ,`SchoolElementary` = 'ROBERTS ELEMENTARY SCHOOL (BRAZOSPORT)' ,`SchoolHigh` = 'BRAZOSWOOD HIGH SCHOOL' ,`SchoolMiddle` = 'LAKE JACKSON INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Plantation Village' ,`TaxAmount` = '6224' ,`TaxRate` = '2.3371' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1991' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669649787' WHERE `Matrix_Unique_ID` = '214007037' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-26T18:53:41.550' ,`MLSNumber` = '32725929' ,`ListAgentFullName` = 'Roscoe Ford' ,`ListOfficeName` = 'JPAR-The Sears Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.311974' ,`Longitude` = '-96.085897' ,`PhotoCount` = '48' ,`PostalCode` = '77488' ,`RoomCount` = '16' ,`ListPrice` = '329900.00' ,`Status` = 'Active' ,`StreetName` = 'Hodges' ,`StreetNumber` = '1305' ,`StreetSuffix` = 'Lane' ,`City` = 'Wharton' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '3155' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This Amazing 3/4 bed, 4.5 bath custom home w/ private tennis court on just less than a 1/2 acre lot in the heart of beautiful Wharton, TX! This 2 story home on a corner lot is nestled between 2 huge live oak trees and adjacent to large hay fields offering a sense of privacy. The expansive living room w/ wood burning fireplace features a wall of windows overlooking the private backyard & tennis court. Kitchen w/ updated silestone counter tops, slate floors, white custom cabinets, double ovens and an abundance of storage. Huge laundry room w/ tons of cabinet storage, a sink and spot for a frig or freezer. Large master bedroom w/ built-ins for extra storage and a French door leading to a private covered patio. Two separate master bathrooms including an updated walk-in shower. Large gameroom upstairs along w/ both secondary ensuite bedrooms, each boasting a full bathroom. Recent 30 year 3D roof, Recent gutters. Recent tankless water heater. No HOA. Low taxes. DID NOT flood in Harvey.' ,`Acres` = '0.3948' ,`Area` = '55' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'FRAZIER BLOCK 2 LOT 13A,14' ,`LotDesciption` = 'Corner' ,`LotSize` = '17197' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '180 - Wharton' ,`SchoolElementary` = 'CG SIVELLS/WHARTON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WHARTON HIGH SCHOOL' ,`SchoolMiddle` = 'WHARTON JUNIOR HIGH' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Frazier' ,`TaxAmount` = '6790' ,`TaxRate` = '2.3512' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1970' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669649787' WHERE `Matrix_Unique_ID` = '214024697' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-26T17:23:30.863' ,`MLSNumber` = '2598899' ,`ListAgentFullName` = 'Sam Sharif' ,`ListOfficeName` = 'RE/MAX Elite Properties' ,`SellingAgentFullName` = 'Jennifer Guillen' ,`SellingOfficeName` = 'Guillen Properties' ,`Latitude` = '30.018595' ,`Longitude` = '-95.632446' ,`PhotoCount` = '39' ,`PostalCode` = '77429' ,`RoomCount` = '11' ,`ListPrice` = '600000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Sedgefield Creek' ,`StreetNumber` = '13614' ,`StreetSuffix` = 'Trace' ,`City` = 'Cypress' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3286' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Nestled in the back Enclave at Lakes at Northpointe gated community, this 2019 Ashton Woods beauty features 4 bedroom and 3.5 bath. This 1-story home has everything you need including an open concept, high ceilings throughout and formal dining. The kitchen is a cooks delight with a 5-burner gas stove, extended beautiful granite island with seating and fabulous pull out cabinets offering easy access to cookware. From the 3-car garage to the large covered back patio that backs up to the green belt, this house is turnkey ready. Zoned to Tomball ISD highly rated schools, walking trails for days, neighborhood pool, tennis courts and playground - makes this truly a family home delight! Book your showing today.' ,`Acres` = '0.1924' ,`Area` = '35' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Tomball South/Lakewood' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 14 BLK 2 ENCLAVE AT NORTHPOINTE SEC 6' ,`LotDesciption` = 'Greenbelt' ,`LotSize` = '8380' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1150' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'WILDWOOD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL MEMORIAL H S' ,`SchoolMiddle` = 'WILLOW WOOD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Enclave/Northpointe' ,`TaxAmount` = '11764' ,`TaxRate` = '3.0164' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669649787' WHERE `Matrix_Unique_ID` = '214281710' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-26T18:04:24.843' ,`MLSNumber` = '70806543' ,`ListAgentFullName` = 'Mike Mahlstedt' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = 'Kyla Phung Linn' ,`SellingOfficeName` = 'Compass RE Texas, LLC' ,`Latitude` = '29.808649' ,`Longitude` = '-95.386855' ,`PhotoCount` = '16' ,`PostalCode` = '77009' ,`RoomCount` = '8' ,`ListPrice` = '579000.00' ,`Status` = 'Option Pending' ,`StreetName` = '25th' ,`StreetNumber` = '906' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1456' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Fabulous find in the heart of Sunset Heights. This charming Heights Bungalow, with native Texas Landscape, has 3 bedrooms, 2 bathrooms and offers a flowing, open floor plan with a wonderful sized backyard that is lushly landscaped. The home has an abundance of natural light, wood floors and tile floors, iron remote controlled driveway gate, recent updates throughout the home and a fantastic back deck for entertaining.' ,`Acres` = '0.1653' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Heights/Greater Heights' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LTS 3 & 4 & TR 5A BLK 61 SUNSET HEIGHTS' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7200' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'FIELD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HEIGHTS HIGH SCHOOL' ,`SchoolMiddle` = 'HAMILTON MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Craftsman,Traditional' ,`Subdivision` = 'Sunset Heights' ,`TaxAmount` = '12755' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1940' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669649787' WHERE `Matrix_Unique_ID` = '214286947' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-26T18:51:51.073' ,`MLSNumber` = '42122717' ,`ListAgentFullName` = 'Ariston Cabangbang' ,`ListOfficeName` = 'Cabangbang Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.654113' ,`Longitude` = '-95.345534' ,`PhotoCount` = '9' ,`PostalCode` = '77033' ,`RoomCount` = '3' ,`ListPrice` = '199999.00' ,`Status` = 'Active' ,`StreetName` = 'Higgins' ,`StreetNumber` = '5122' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1056' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful, completely remodeled home! Boasting 3 bedrooms and 2 baths, this one story home has all new paint inside and outside, new carpet in all bedrooms, and completely updated modern bathrooms. The home features beautiful laminate flooring in the main area, new cabinets, granite countertops, stainless steel appliances, new HVAC system, and a new Roof. Close to 610, and approximately 20 min to popular Houston city attractions and the Downtown area. This is a must see! Schedule your showing today!' ,`Acres` = '0.1818' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Medical Center South' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 17 BLK J SUNNYSIDE GARDENS' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7920' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'WOODSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'STERLING HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'THOMAS MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Sunnyside Gardens' ,`TaxAmount` = '1279' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1947' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669649788' WHERE `Matrix_Unique_ID` = '214325715' --> Updated record success
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','214366928','1669649788','214366928','2022-11-26T17:48:50.867','47062153','Berenice Van den Bergh','White Line Realty','Sheryl Vecchio','eXp Realty, LLC','30.109814','-95.515697','34','77389','1','510000.00','Option Pending','Inway','6203','Drive','Spring','3','1','4','2850','Single-Family','Welcome to this stunningly remodeled home on a large corner lot in the highly desirable Northampton community. You will love the open concept on the first floor with tons of natural light, cathedral ceilings, wet bar, fire place, and more. Nothing was left untouched: all new kitchen, bathrooms, paint, railings, light & plumbing fixtures, new windows, new PEX plumbing, new concrete patio, new luxury vinyl plank floors on first AND second floor, and SO MUCH MORE you\'ll need to see for yourself. The large primary bedroom on first floor with en-suite bath boasts custom his and hers closets. Upstairs you will find a secondary bedroom with private en-suite bathroom as well as two more bedrooms with spacious Jack-and-Jill style bathroom. Community amenities include two pools, club house, monthly family activities, gym, several park with playgrounds, and more! Come see this beauty while you can!','0.3954','14','','','','','Mud,Sellers Disclosure','1','','1','Spring/Klein','Central Electric','1','LT 26 BLK 20 017*N5959000-005-020-026 NORTHAMPTON SEC 5 2ND','Corner,In Golf Course Community','17223','Appraisal District','','385','0','','3','','0','','','','','Composition','32 - Klein','NORTHAMPTON ELEMENTARY SCHOOL','KLEIN OAK HIGH SCHOOL','HILDEBRANDT INTERMEDIATE SCHOOL','Appointment Required,Lockbox Front,Vacant/Unoccupied','Seller','2','Traditional','Northhampton Sec 05 02 Rep','8099','2.664','Water District','1974','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-26T17:07:41.570' ,`MLSNumber` = '5938761' ,`ListAgentFullName` = 'Karina Rojas' ,`ListOfficeName` = 'Keller Williams Metropolitan' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.811414' ,`Longitude` = '-95.493607' ,`PhotoCount` = '37' ,`PostalCode` = '77055' ,`RoomCount` = '9' ,`ListPrice` = '399999.00' ,`Status` = 'Active' ,`StreetName` = 'Restridge' ,`StreetNumber` = '2107' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '6' ,`SqFtTotal` = '4174' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '?? Stunning two-story home is on a large lot in a hot neighborhood near parks, schools, stores & entertainment places waiting for you to make your mark!. Recently renovated with new luxury vinyl plank flooring, fresh painting and new carpet . This property has to offer a beautiful & large kitchen/breakfast nook combo area. 3/2 first story with an open floor plan that also connect very well the formal dining room, living room and library. 2/1 independent guess - studio area with living & kitchen .2/1second floor with a large game room. Spacious and nice backyard ready to gather friends and family. ' ,`Acres` = '0.1742' ,`Area` = '24' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 102 BLK 7 SPRINGDALE SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7590' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '4' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'RIDGECREST ELEMENTARY SCHOOL (SPRING BRANCH)' ,`SchoolHigh` = 'NORTHBROOK HIGH SCHOOL' ,`SchoolMiddle` = 'LANDRUM MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Springdale Sec 02' ,`TaxAmount` = '9159' ,`TaxRate` = '2.4415' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1955' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1669649788' WHERE `Matrix_Unique_ID` = '214394795' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-26T18:42:26.900' ,`MLSNumber` = '21715367' ,`ListAgentFullName` = 'Allison Tims' ,`ListOfficeName` = 'Texas Premier Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.286297' ,`Longitude` = '-95.478874' ,`PhotoCount` = '22' ,`PostalCode` = '77304' ,`RoomCount` = '10' ,`ListPrice` = '324900.00' ,`Status` = 'Active' ,`StreetName` = 'Windsor' ,`StreetNumber` = '19' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2436' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'KITCHEN RECENTLY COMPLETEY UPDATED with Beautiful QUARTZ Countertops! New Backsplash. ALL NEW FLOORING Downstairs!! HUGE PRIMARY SUITE with Huge Walk-in Closet and Double Doors to In-suite Bathroom with Soaking Tub!! . All nice size BR\'s with Walk-in Closets! BRAND NEW AC!! NEW ELECTRIC PANEL! NEW Dishwasher! NEW Fence with Double Gates! NEW push button Toilets! Kitchen has New Disposal, New Sink, Updated Lighting and New Paint! Features gas appliances and opens to breakfast and family room. Lots of windows to invite natural sunlight! Both formals. Covered Patio overlooks Large Private Backyard with a very nice sized Shed with AC! LARGE LOT. Centrally located just minutes to I-45, Lake Conroe is Only 15 Minutes Away! Woodlands Mall 10 minutes away! Brand new stores all around!! You Are Going to LOVE Living Here!!' ,`Acres` = '0.2348' ,`Area` = '19' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure,Tenant Occupied' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Conroe Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'RIVERSHIRE 02 BK 7 LT 35&W31\'OF LT 36' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10229' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '275' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'RICE ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Colonial' ,`Subdivision` = 'Rivershire 02' ,`TaxAmount` = '6586' ,`TaxRate` = '2.1863' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1992' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669649788' WHERE `Matrix_Unique_ID` = '214398855' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-26T18:17:41.043' ,`MLSNumber` = '46544329' ,`ListAgentFullName` = 'Ashley Copeland' ,`ListOfficeName` = 'Pam\'s Home Team' ,`SellingAgentFullName` = 'Fernanda Saliba' ,`SellingOfficeName` = 'Lucky Money Real Estate' ,`Latitude` = '30.137645' ,`Longitude` = '-95.420903' ,`PhotoCount` = '35' ,`PostalCode` = '77386' ,`RoomCount` = '4' ,`ListPrice` = '340000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Buchans' ,`StreetNumber` = '1415' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1849' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 1 story in the desirable subdivision of Imperial Oaks! Minutes to I45,Grand Parkway&Hardy Toll Rd! This lovely home has been COMPLETELY UPDATED & offers 4 spacious bedrooms & 2 full, updated bathrooms! The redesigned kitchen features custom soft close cabinets/drawers/pantry drawers, granite countertops, custom built mesquite butcher block island, stainless steel appliances & under cabinet lighting! Both bathrooms offer updated showers/tubs, toilets, soft close cabinets, hardware, fixtures, sinks & granite! Tile floors, updated fixtures & hardware throughout, shiplap fireplace in the living room & a custom built mudroom entryway/foyer are just a few of the upgrades that make this home extraordinary! Great curb appeal w/ meticulously maintained flower beds! Exterior features include a sprinkler system, fenced back yard & a large covered patio. Zoned to excellent CISD Schools & sought after Kaufman Elementary! Walk to subdivision parks, pool, basketball & tennis courts!' ,`Acres` = '0.177' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S611505 - IMPERIAL OAKS 05, BLOCK 9, LOT 3 (PARTIAL REPLAT)' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7710' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '455' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'KAUFMAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'OAK RIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'IRONS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Imperial Oaks' ,`TaxAmount` = '5048' ,`TaxRate` = '2.4827' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1997' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669649788' WHERE `Matrix_Unique_ID` = '214412362' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-26T17:07:41.570' ,`MLSNumber` = '54118990' ,`ListAgentFullName` = 'Martin Reyes' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.971981' ,`Longitude` = '-95.442205' ,`PhotoCount` = '39' ,`PostalCode` = '77014' ,`RoomCount` = '10' ,`ListPrice` = '236000.00' ,`Status` = 'Active' ,`StreetName` = 'Ridgebriar' ,`StreetNumber` = '1623' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1594' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to 1623 Ridgebriar Drive. Location, beauty and character. This beautiful 3 Bedroom home is ready to be your home! Tile and laminate flooring throughout. Split floor plan. Spacious kitchen with lots of storage, large dining room, and spacious living room with high ceiling. The master bedroom has an addition that could be used as the 4th bedroom. About 22 minutes from Downtown Houston, The Woodlands, and George Bush International Houston Airport, just 16 minutes from Willowbrook Mall, and just 4 minutes from the North Houston Skate Park. Home has an outside 9X7 shed with electricity. Beautiful front and back yards, gutters throughout and spacious double wide driveway. Come see it today!' ,`Acres` = '0.1664' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '1960/Cypress Creek South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 135 BLK 11 CRANBROOK SEC 2 PAR R/P' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7249' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'CLARK ELEMENTARY SCHOOL (SPRING)' ,`SchoolHigh` = 'ANDY DEKANEY H S' ,`SchoolMiddle` = 'STELLE CLAUGHTON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Cranbrook Sec 02 Prcl R/P' ,`TaxAmount` = '4283' ,`TaxRate` = '2.7192' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1993' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669649789' WHERE `Matrix_Unique_ID` = '214453165' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-26T18:48:08.720' ,`MLSNumber` = '33907526' ,`ListAgentFullName` = 'Denise Moore' ,`ListOfficeName` = 'Jane Byrd Properties INTL.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.084537' ,`Longitude` = '-95.193539' ,`PhotoCount` = '15' ,`PostalCode` = '77339' ,`RoomCount` = '8' ,`ListPrice` = '259000.00' ,`Status` = 'Active' ,`StreetName` = 'Manor Forest' ,`StreetNumber` = '5711' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1760' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Take a look at this 2 story home on a cul-de-sac street. Vinyl plank flooring flows seamlessly throughout the entire downstairs living spaces. High vaulted ceilings, formal dining and two downstairs living areas. This is an exceptional floorplan for easy living. Huge fenced backyard. New 50 year roof placed 09/2022. Per Seller - NO Flooding!' ,`Acres` = '0.1736' ,`Area` = '32' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Kingwood West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 25 BLK 36 ELM GROVE VILLAGE SEC 3' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot,Wooded' ,`LotSize` = '7560' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'ELM GROVE ELEMENTARY SCHOOL (HUMBLE)' ,`SchoolHigh` = 'KINGWOOD PARK HIGH SCHOOL' ,`SchoolMiddle` = 'KINGWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Elm Grove Village Sec 03' ,`TaxAmount` = '4647' ,`TaxRate` = '2.5839' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1988' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669649789' WHERE `Matrix_Unique_ID` = '214503143' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-26T18:15:22.053' ,`MLSNumber` = '65300767' ,`ListAgentFullName` = 'Glenn Barnes' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.467673' ,`Longitude` = '-95.466416' ,`PhotoCount` = '25' ,`PostalCode` = '77583' ,`RoomCount` = '8' ,`ListPrice` = '259988.00' ,`Status` = 'Active' ,`StreetName` = 'Ashley Falls' ,`StreetNumber` = '602' ,`StreetSuffix` = 'Lane' ,`City` = 'Rosharon' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1685' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Home has an assumable 2.99% mortgage. Live comfortably in this lovely 3 bedroom, 2-bathroom home in Southern Colony. High ceilings, wood flooring, formal living room, dining room, and a covered patio in the expansive backyard. The primary suite is large ( as pictured the room easily accommodates a king size bed, two night stands, two wardrobe chests, and still has plenty of room to move around). The home features several options for storage with a large shed in the rear, and several garage storage options. Smart features, include a smart garage, thermostat, locks, and a Rachio managed sprinkler system (that automatically adjusts for weather and soil saturation levels). You willbe minutes from the new 288 Highway 6 shopping center. New High school currently being built in the area. Take advantage now.' ,`Acres` = '0.1377' ,`Area` = '38' ,`BuilderName` = 'DR Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Sienna Area' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SOUTHERN COLONY SEC 4A, BLOCK 6, LOT 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'HERITAGE ROSE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Right Side,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Southern Colony Sec 4a' ,`TaxAmount` = '6457' ,`TaxRate` = '3.1329' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1669649789' WHERE `Matrix_Unique_ID` = '214552254' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-26T17:07:41.570' ,`MLSNumber` = '56288611' ,`ListAgentFullName` = 'Spencer Huck' ,`ListOfficeName` = 'CitiQuest Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.811955' ,`Longitude` = '-95.398559' ,`PhotoCount` = '39' ,`PostalCode` = '77008' ,`RoomCount` = '6' ,`ListPrice` = '749990.00' ,`Status` = 'Active' ,`StreetName` = '28th' ,`StreetNumber` = '112' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2959' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MOVE IN READY! Welcome to Sunset Villas by TOMO Homes. In the heart of the Heights, these stunning 2.5 story homes boast 3,000 sqft with a unique open floor plan that features 4 beds, 3.5 baths, first floor living, large primary and secondary bedrooms, and a game room with an oversized covered terrace overlooking the large backyard (ready for a pool) , perfect for entertaining! Interior design includes an open kitchen with calacatta quartz waterfall island, shaker cabinets, Fisher & Paykel stainless steel appliances, gas fireplace, wine cooler, two wet bars and beautiful wood flooring throughout. The primary bedroom features an oversized walk-in closet, frameless glass shower and an elegant soaking tub. This home is ELEVATOR READY and offers ample storage space! Additional features include, walk-in utility room and pantry, prewires security cameras, private driveways and no HOA! Enjoy this home\'s central location with quick freeway access to your favorite restaurants, bars, and parks!' ,`Acres` = '0.1377' ,`Area` = '9' ,`BuilderName` = 'TOMO Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Heights/Greater Heights' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LTS 5 & 6 BLK 16 SUNSET HEIGHTS' ,`LotDesciption` = 'Other,Subdivision Lot' ,`LotSize` = '3000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'HELMS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HEIGHTS HIGH SCHOOL' ,`SchoolMiddle` = 'HAMILTON MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Accompany' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2.5' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Sunset Heights' ,`TaxAmount` = '6526' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669649789' WHERE `Matrix_Unique_ID` = '214563069' --> Updated record success
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','214623346','1669649790','214623346','2022-11-26T17:42:03.360','34332708','Natalie Villaquiran','CyHou Realty','','','29.592893','-95.696846','19','77479','8','400000.00','Active','Cantrell','4206','Court','Sugar Land','3','1','4','2982','Single-Family','If you are looking for a home with plenty space both inside and out, this is the one for you.\r\nLocated on over 12000 square foot cul-de-sac lot, this home features an oversized backyard with a beautiful pool & plenty of yard space for outdoor activities. Enjoy plenty of privacy with a fully fenced in backyard and no back neighbors. Inside, the first floor features tile in the kitchen area, breakfast, formal dining room and half bath with engineered hardwood floor throughout the rest of the first floor, including primary bedroom. The spacious primary bedroom with ensuite bath is on the first floor with windows highlighting the view of the backyard. The family room is the center of the home with high ceilings and a wall of windows. Upstairs you will find a jack-and jill layout (2 bedrooms)with shared bathroom and another spacious bedroom and additional full bathroom. Enjoy the many amenities of New Territory, including The Club, and several parks and pools within walking distance.','0.2811','29','','','Gas Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','Freestanding,Gaslog Fireplace','1','Sugar Land West','Central Electric','1','AUTUMN RIDGE SEC 1, BLOCK 1, LOT 18','Cul-De-Sac,Subdivision Lot','12243','Appraisal District','','1135','0','','2','Electric Oven','1','Gunite','','Gas Range','','Composition','19 - Fort Bend','BRAZOS BEND ELEMENTARY SCHOOL','TRAVIS HIGH SCHOOL (FORT BEND)','SARTARTIA MIDDLE SCHOOL','Accompany,Appointment Required,Supra Keybox','Appraisal District','2','Traditional','Autumn Ridge Sec 1','7907','2.4394','Water District','1994','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-26T17:36:28.530' ,`MLSNumber` = '35217546' ,`ListAgentFullName` = 'Long Nguyen' ,`ListOfficeName` = '5th Stream Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.568935' ,`Longitude` = '-95.019985' ,`PhotoCount` = '29' ,`PostalCode` = '77586' ,`RoomCount` = '4' ,`ListPrice` = '275500.00' ,`Status` = 'Active' ,`StreetName` = 'Capri' ,`StreetNumber` = '1729' ,`StreetSuffix` = 'Lane' ,`City` = 'Seabrook' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1700' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A beautiful recently full remodeling House that\'s located minutes away from \"Kemah Boardwalk\". It can be a great starting home or a great long term or short term (Airbnb) rental investment property.\r\nBelow are all newly replacements:\r\n- All interior new paint\r\n- Two bathrooms full remodeled: walls up with 12x24 tile and Granite vanity countertops\r\n- New paint kitchen cabinets and Granite kitchen countertop\r\n- New 5mm Luxury Vinyl Plank wood look \"click & lock\" in all Common area and bedroom floors \r\n- New AC' ,`Acres` = '0.1515' ,`Area` = '7' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Clear Lake Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 16 BLK 3 MIRAMAR SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '52' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'BAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR FALLS HIGH SCHOOL' ,`SchoolMiddle` = 'SEABROOK INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Miramar Sec 03' ,`TaxAmount` = '4016' ,`TaxRate` = '2.2905' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1969' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669649790' WHERE `Matrix_Unique_ID` = '214654977' --> Updated record success
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','214721980','1669649790','214721980','2022-11-26T17:46:13.250','60855381','Linda Bovasso','JLA Realty','Shaye Grant','Opendoor Brokerage, LLC','30.121426','-95.241868','25','77365','7','250000.00','Option Pending','Toronado Ridge','22509','Lane','Porter','2','0','3','1365','Single-Family','Charming one-story brick DR Horton home situated on a large corner lot in the highly desired community of Valley Ranch. Welcoming gated front porch leads into a cozy living room that opens into a delightful kitchen featuring laminate wood flooring, beautiful farmhouse sink, concrete countertops, and stylish cabinetry. Quaint kitchen includes a breakfast area spacious enough to seat 6 people. Utility room is conveniently located off the kitchen area. Private primary suite located in the back of the house features double sinks, a walk-in shower and separate tub. The two secondary bedrooms and second bath are in the front of the home. Property includes a large back yard and spacious side yard. Roof replacement in 2022.','0.1445','40','','','Electric Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','','','Porter/New Caney West','Central Gas','1','S941205 - VALLEY RANCH 05, BLOCK 1, LOT 6','Corner,Subdivision Lot','6295','Appraisal District','','800','0','','2','Gas Oven','0','','','Freestanding Range','','Composition','39 - New Caney','VALLEY RANCH ELEMENTARY SCHOOL (NEW CANEY)','NEW CANEY HIGH SCHOOL','NEW CANEY MIDDLE SCHOOL','Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox','Appraisal District','1','Traditional','Valley Ranch 05','5127','3.2331','Public Sewer,Water District','2011','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-26T17:47:19.907' ,`MLSNumber` = '47675809' ,`ListAgentFullName` = 'Patrick Lalezari' ,`ListOfficeName` = 'Summit Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.586809' ,`Longitude` = '-95.547861' ,`PhotoCount` = '47' ,`PostalCode` = '77459' ,`RoomCount` = '9' ,`ListPrice` = '249000.00' ,`Status` = 'Active' ,`StreetName` = 'Creekway' ,`StreetNumber` = '2910' ,`StreetSuffix` = 'Circle' ,`City` = 'Missouri City' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1788' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Location! Location! Location! This spacious & beautiful 3 bedroom and 2 bathroom home is located minutes away from the Quail Valley Golf Course and the Quail Valley City Center in the beautiful Meadowcreek neighborhood. It has a large family room, a formal dining room that is open to the roomy kitchen, and a spacious backyard. The family room includes a fireplace and has lots of natural lighting. The kitchen has brand new stainless steel appliances, new granite counters, fresh new paint throughout the home, new flooring, and a laundry room area inside the home. The main room is very spacious, with lots of natural lighting and access to the backyard. The main bathroom has double sinks and granite counters. Other bedrooms offer hardwood floors, ceiling fans, and sizable closets. Home backs up into Independence Park which has a boat ramp, fishing pier, and walking trail. Easy access to Hwy 90, Fort Bend Tollway & Medical Center, restaurants, and entertainment.' ,`Acres` = '0.1405' ,`Area` = '38' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Missouri City Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'MEADOWCREEK SEC 4, BLOCK 8, LOT 10' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6120' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'QUAIL VALLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ELKINS HIGH SCHOOL' ,`SchoolMiddle` = 'QUAIL VALLEY MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Meadowcreek Sec 4' ,`TaxAmount` = '2190' ,`TaxRate` = '2.5839' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '1980' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669649790' WHERE `Matrix_Unique_ID` = '214744725' --> Updated record success
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','214785158','1669649790','214785158','2022-11-26T17:23:03.160','216626','Marsha Crawford','UTR TEXAS, REALTORS','','','29.468293','-95.239169','39','77511','7','240000.00','Active','Carmichael','5303','Circle','Alvin','2','0','3','1314','Single-Family','Well maintained 3/2/2 on a quiet cul-de-sac street. Fresh paint throughout the interior & new carpet installed in November 2022. The kitchen features granite counters, 42-inch espresso cabinets, stainless sink. The kitchen is open to the dining area & family room. The owner\'s suite is located at the back of the home for added privacy, featuring an en-suite bath with granite counters, dual lavatories, oversize shower & spacious walk-in closet. Split plan with 2 other bedrooms & a full bath. Wonderful oversize covered back porch - perfect for morning coffee or afternoon tea. Home has all 4 sides brick, gutters, nice landscaping. This home is truly move-in ready - please call for your private showing - won\'t last!','0.1084','5','Grand View Builders','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','','','Alvin North','Central Gas','1','NORTH POINTE TRAILS SEC 2 (A0693 I & G N)(ALVIN) BLK 2 LOT 5','Cul-De-Sac,Subdivision Lot','4722','Appraisal District','','29','0','','2','Freestanding Oven,Gas Oven','0','','','Freestanding Range,Gas Range','','Composition','3 - Alvin','HASSE ELEMENTARY SCHOOL (ALVIN)','ALVIN HIGH SCHOOL','G W HARBY J H','Appointment Required,Lockbox Front,Supra Keybox','Appraisal District','1','Traditional','North Pointe Trails Sec 2','5261','2.8854','Public Sewer,Public Water','2014','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','214930354','1669649790','214930354','2022-11-26T18:07:30.913','97154714','Thomas Collins','Redfin Corporation','','','29.652710','-95.489528','46','77035','11','299000.00','Active','Burlinghall','5811','Drive','Houston','2','0','3','1891','Single-Family','Lovely home with updates and bright, open spaces! Step inside to gorgeous wood floors that stretch throughout the front formal dining and living rooms. Large picture window makes for great light in a space that could be a formal living, office, playroom, you name it! Easy to maintain tile floors in the living room with sliding glass doors and backyard views. Kitchen features granite counters, on-trend white cabinets, and breakfast bar. Retreat to the primary bedroom with an updated en-suite bath. Two more spacious bedrooms share a bath. All bedrooms have wood floors - NO carpet! Don\'t miss the fully fenced backyard with a large patio, perfect for a dining set and evenings outside. Plenty of green space and a beautiful mature tree ensure hours of fun outside. Per seller, 2018 HVAC replacement (unit and ducts), 2013 30 yr roof, Grade A Uponor PEX re-pipe for the entire home, 2022 new windows. Convenient location near schools and parks in a neighborhood with picturesque mature trees!','0.1928','20','','','Electric Dryer Connections','','Sellers Disclosure','1','','','Brays Oaks','Central Electric','0','LT 6 BLK 73 WESTBURY SEC 3','Subdivision Lot','8400','Appraisal District','','','0','','2','Electric Oven','0','','','Electric Cooktop','','Composition','27 - Houston','ANDERSON ELEMENTARY SCHOOL (HOUSTON)','WESTBURY HIGH SCHOOL','FONDREN MIDDLE SCHOOL','Appointment Required,Supra Keybox','Appraisal District','1','Traditional','Westbury Sec 03','6735','2.3307','Public Sewer,Public Water','1958','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-26T17:07:41.570' ,`MLSNumber` = '88579728' ,`ListAgentFullName` = 'Jennifer Francois' ,`ListOfficeName` = 'Keller Williams Premier RealtyKaty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.573964' ,`Longitude` = '-95.594000' ,`PhotoCount` = '32' ,`PostalCode` = '77479' ,`RoomCount` = '9' ,`ListPrice` = '350000.00' ,`Status` = 'Active' ,`StreetName` = 'Flintrock' ,`StreetNumber` = '3811' ,`StreetSuffix` = 'Lane' ,`City` = 'Sugar Land' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1843' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home! This stunning 3 bedroom, 2.5 bathroom property features a 2-car attached garage with impeccable curb appeal, a full brick surrounded exterior elevation, mature shade trees, and an expertly maintained lawn. Step inside & fall in love with the open, inviting layout- perfect for entertaining! The interior boasts impressive-sized rooms, a formal sitting area, a formal dining room, a chef\'s kitchen, and a spacious living room with a cozy wood-burning fireplace. Upstairs find the luxurious primary suite and two additional guest rooms. You\'ll find timeless wood and tile flooring, decorator paint, ceiling fans, bright natural light, and upgraded plantation shutter blinds throughout the home. The kitchen is the true heart of the house- features include Granite countertops, upgraded cabinetry, designer pulls, and stainless steel appliances. This home is only a short walk away from the elementary school and is conveniently located near shops & restaurants with easy access to Hwy 6!' ,`Acres` = '0.1717' ,`Area` = '29' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sugar Land South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SETTLERS GROVE SEC 1, BLOCK 5, LOT 11' ,`LotDesciption` = 'Subdivision Lot,Wooded' ,`LotSize` = '7478' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '495' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'SETTLERS WAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEMENTS HIGH SCHOOL' ,`SchoolMiddle` = 'FIRST COLONY MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Settlers Grove' ,`TaxAmount` = '5641' ,`TaxRate` = '2.1584' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1983' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669649790' WHERE `Matrix_Unique_ID` = '214934067' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-26T18:32:11.233' ,`MLSNumber` = '91008220' ,`ListAgentFullName` = 'Kristy Pennetta' ,`ListOfficeName` = 'Real Property Management Prefe' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.843763' ,`Longitude` = '-95.638977' ,`PhotoCount` = '8' ,`PostalCode` = '77084' ,`RoomCount` = '3' ,`ListPrice` = '265000.00' ,`Status` = 'Active' ,`StreetName` = 'Hickory Downs' ,`StreetNumber` = '4711' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1834' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Don\'t miss out on this beauty! Spacious light and bright single story in the well-established Bear Creek Village. The living area brings in plenty of natural light with the skylights and a cozy fireplace. The kitchen has plenty of storage and counter space, stainless appliances and a breakfast bar. The 3 bedrooms are spacious with walk in closets. \r\nThis beauty would be a wonderful place to call HOME!!' ,`Acres` = '0.1613' ,`Area` = '8' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 64 BLK 16 BEAR CREEK VILLAGE SEC 9' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7025' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '475' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'BEAR CREEK ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'MAYDE CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'CARDIFF JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Bear Creek Village Sec 09' ,`TaxAmount` = '4744' ,`TaxRate` = '2.1736' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1977' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669649790' WHERE `Matrix_Unique_ID` = '214968024' --> Updated record success
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215037467','1669649791','215037467','2022-11-26T17:40:38.157','74774862','Brandi Jackson','Berkshire Hathaway HomeServices Premier Properties','','','30.230577','-95.442578','35','77385','7','299500.00','Active','Brook Hollow','621','Drive','Conroe','2','1','3','2350','Single-Family','Nestled in the prestigious Riverbrook Forest Hills, this hard-to-find charming waterfront delivers gorgeous views of Forest Hills Lake from almost every window of the house! The outdoor oasis delivers a new redwood deck, an enormous yard, a carport large enough to house three vehicles & a newly replaced private concrete driveway! Featuring newer stainless-steel appliances, including a double oven & a fridge that stays, entertain in your adjoining breakfast room & formal dining. The first floor provides a primary retreat with an en-suite bath & large vanity, & an additional bedroom nearby. Take the Stair Lift upstairs to find an additional primary suite featuring a soaking tub, separate shower & generous walk-in closet. Appreciate newly painted interior walls, the freshly painted exterior, exterior wood replaced/painted, & a sprinkler system upgrade. Zoned to Conroe ISD & minutes to restaurants, shopping, The Woodlands & more. Come enjoy waterfront living here!','0.3031','15','','','Washer Connections','','Mud,Sellers Disclosure','1','Gas Connections,Gaslog Fireplace,Wood Burning Fireplace','1','Conroe Southeast','Central Gas','1','RIVERBROOK-FOREST HLS, LOT 27','Subdivision Lot,Waterfront','13201','Appraisal District','','330','0','','2','Double Oven,Electric Oven','0','','','Electric Cooktop','','Composition','11 - Conroe','WILKINSON ELEMENTARY SCHOOL','CONROE HIGH SCHOOL','STOCKTON JUNIOR HIGH SCHOOL','Appointment Required,Lockbox Front,Supra Keybox','Appraisal','1.5','Traditional','Riverbrook-Forest Hls','4345','2.3044','Water District','1970','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215040679','1669649791','215040679','2022-11-26T18:21:29.763','6695431','Thao Nguyen','eXp Realty, LLC','','','29.700099','-95.631687','27','77083','6','260000.00','Active','Aurora Falls Lane','7114','','Houston','2','1','3','1516','Single-Family','Newly renovated 3 beds, 2.5 baths, 2-story home. Modern customized kitchen cabinets, quartz countertop with new gas range and dishwasher. Open concept floor plan connecting the kitchen to to dining Room and large family room. Beautiful wood luxury vinyl flooring through out the house. Owner\'s Retreat with walk-in closet and a huge shower. Big gameroom on the second floor. House is located in quiet cul-de-sac neighborhood. Same Owners have been living there for over 10 years.','','28','','','Electric Dryer Connections,Gas Dryer Connections','','No Disclosures,Real Estate Owned,Special Addendum','1','','','Alief','Central Gas','1','LT 22 BLK 2 LAKES OF BELLAIRE SEC 4','Subdivision Lot','3491','Appraisal District','','300','0','','2','Gas Oven','0','','','Gas Range','','Composition','2 - Alief','HEARNE ELEMENTARY SCHOOL (ALIEF)','AISD DRAW','ALBRIGHT MIDDLE SCHOOL','Lockbox Front','Builder','2','Traditional','LAKES OF BELLAIRE SEC 4','4787','2.397','Public Sewer,Public Water','2006','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215045363','1669649791','215045363','2022-11-26T18:29:27.907','69967758','Luis F. Mendoza','Veronica Mendoza Realty, LLC.','','','29.744308','-95.638996','29','77077','9','350000.00','Active','Briarworth','14111','Drive','Houston','2','1','4','2006','Single-Family','A very well-kept home, a corner location, offers both formal areas, a large Den with WBFP, an updated Kitchen with double oven and bathrooms, replaced energy efficient windows and back patio sliding french door, an extra sunroom, all ceramic tile floors, a good roof, good AC system, and a great location!!','0.1919','31','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','Wood Burning Fireplace','1','Energy Corridor','Central Electric','1','LT 21 BLK 21 BRIAR VILLAGE SEC 4','Corner,Subdivision Lot','8360','Appraisal District','','495','0','','1','Double Oven,Electric Oven','0','','','Electric Cooktop','','Composition','27 - Houston','DAILY ELEMENTARY SCHOOL','WESTSIDE HIGH SCHOOL','WEST BRIAR MIDDLE SCHOOL','Appointment Required,Lockbox Front','Appraisal District','1','Traditional','Briar Village Sec 04','7698','2.3307','Public Sewer,Public Water','1976','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215067711','1669649791','215067711','2022-11-26T17:45:57.213','41028938','Nolan Nix','Home Run Realty','Glenda Bass','Keller Williams RealtyNortheast','30.056995','-95.220699','10','77339','8','199900.00','Option Pending','Round Spring','2018','Drive','Kingwood','2','1','4','2039','Single-Family','Wonderful Opportunity to Own an Upfront Woodland Hills 4 Bedroom Home. Master Down. High Ceilings in Family Room. Formal Living Room or Dining Room, Study and Primary Bedroom all Downstairs! Wet Bar off Family Room. 3 Bedrooms Up. 2 Car Detached Garage. Large Backyard with Room for a Pool. Close Distance to Woodland Hills Park/Pool. Home will need TLC but has lots to offer. Home being Sold As-Is and No Repairs will be made.','0.2041','32','','','Electric Dryer Connections,Washer Connections','','Estate,Sellers Disclosure','0','Gas Connections','1','Kingwood West','No Heating','1','LT 40 BLK 33 WOODLAND HILLS VLG SEC 1 R/P','Subdivision Lot','8892','Appraisal District','','350','0','','2','Double Oven','0','','','Electric Cooktop','','Composition','29 - Humble','WOODLAND HILLS ELEMENTARY SCHOOL','KINGWOOD PARK HIGH SCHOOL','KINGWOOD MIDDLE SCHOOL','Appointment Required,Lockbox Front,Supra Keybox','Appraisal District','2','Traditional','Woodland Hills Village','4884','2.5839','Public Sewer,Public Water','1976','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215073385','1669649791','215073385','2022-11-26T17:29:23.770','26657809','Feras Rachid','Opendoor Brokerage, LLC','','','29.972512','-95.223839','17','77396','3','240000.00','Active','Hannah Oaks','17435','Lane','Humble','2','0','3','1390','Single-Family','Fantastic home in sought after location! This home has fresh interior paint. Windows create a light filled interior with well placed neutral accents. Step into the kitchen, complete with an eye catching stylish backsplash. You won’t want to leave the serene primary suite, the perfect space to relax. Other bedrooms provide nice flexible living space. The primary bathroom is fully equipped with a separate tub and shower, double sinks, and plenty of under sink storage. Take it easy in the fenced in back yard. The sitting area makes it great for BBQs! Hurry, this won’t last long! This home has been virtually staged to illustrate its potential.','0.1241','1','','','','','Sellers Disclosure','1','','0','Humble Area East','Central Gas','1','LT 45 BLK 1 BLACKSTONE CREEK SEC 1','Subdivision Lot','5406','Appraisal District','','385','0','','2','','0','','','','','Other','29 - Humble','RIVER PINES ELEMENTARY SCHOOL','HUMBLE HIGH SCHOOL','HUMBLE MIDDLE SCHOOL','Appointment Required,No Supra Keybox,Vacant/Unoccupied','Seller','1','Traditional','Blackstone Crk Sec 01','5121','2.933','Water District','2012','Seller'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215073449','1669649791','215073449','2022-11-26T17:42:02.080','34878895','Feras Rachid','Opendoor Brokerage, LLC','','','30.043601','-95.397133','19','77373','3','231000.00','Active','Cranberry','23103','Trail','Spring','2','0','3','1508','Single-Family','Your dream home is waiting for you! This home has fresh interior paint. Windows create a light filled interior with well placed neutral accents. Step into the kitchen, complete with an eye catching stylish backsplash. Head to the spacious primary suite with good layout and closet included. Other bedrooms provide nice flexible living space. The primary bathroom features plenty of under sink storage waiting for your home organization needs. Finally, the backyard, a great space for entertaining and enjoying the outdoors. Don\'t miss this incredible opportunity. This home has been virtually staged to illustrate its potential.','0.1591','12','','','','','Sellers Disclosure','1','','0','Spring East','Central Gas','1','LT 7 BLK 17 TIMBER LANE SEC 2','Subdivision Lot','6930','Appraisal District','','396','0','','2','','0','','','','','Other','48 - Spring','PEARL M HIRSCH ELEMENTARY SCHOOL','SPRING HIGH SCHOOL','TWIN CREEKS MIDDLE SCHOOL','Appointment Required,No Supra Keybox,Vacant/Unoccupied','Seller','1','Traditional','Timber Lane Sec 02','6198','3.0268','Other Water/Sewer','1975','Seller'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215075522','1669649791','215075522','2022-11-26T17:26:00.010','84742437','Brian Varvel','Keller Williams Premier RealtyKaty','','','29.975175','-96.408313','39','77418','7','139000.00','Active','Highway 159','10814','','Bellville','1','0','3','1388','Single-Family','Attention all investors! REO property just West of Bellville in Austin County. 3/1 ranch style home with a bonus living quarters on ~1.7 rolling acres in the Bellville countryside. Property also has multiple storage areas around the home. Home has a fairly recent roof, but please note that this property is going to require EXTENSIVE rehab and WILL NOT qualify for financing. Fantastic roadside frontage along FM 159 with plenty of room to expand. Would make an excellent location for a short term rental, or even a small tiny home park. Round Top, Brenham, and Fayettville are all only 30 minutes away. *BOUNDARIES INDICATED IN THE AERIAL PHOTOS ARE ESTIMATES ONLY AND SHOULD BE VERIFIED INDEPENDENTLY.','1.673','57','','','','','No Disclosures','0','','0','','Window Unit','0','A044 GEO GRIMESTRACT 1 & 2','Wooded','72876','Appraisal District','','','0','','0','Electric Oven','0','','','Electric Cooktop','','Composition','136 - Bellville','WEST END ELEMENTARY SCHOOL','BELLVILLE HIGH SCHOOL','BELLVILLE JUNIOR HIGH','Appointment Required,Controlled Access,Lockbox Front','Appraisal District','1','Ranch','George Grimes Surv A-44','2585','1.8096','Septic Tank,Well','1983','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215086232','1669649791','215086232','2022-11-26T17:40:11.027','75292839','Shadrick Bogany','BHGRE Gary Greene','','','30.514465','-94.878181','9','77371','3','350000.00','Active','Buck Creek','450','Road','Shepherd','1','0','1','672','Single-Family','This property is on almost 12 acres with a mobile home 1 bedroom 1 bath and well and septic tank and a small barn. No restrictions and it\'s not far from Trinity River. If you looking for isolation, this is a great location. You\r\ndo have neighbors but not many. The seller is looking for offers on his mini ranch. Live in the country and be close to Coldspring, Goodrich, Shepard and Cleveland, and Livingston.','11.3','64','','','','','Sellers Disclosure','','','','Coldspring/South San Jacinto County','Propane','0','WINDING CREEK #1, LOT 8, 9, ACRES 5.11','Subdivision Lot,Wooded','492228','Appraisal District','','','0','','','Freestanding Oven','0','','','Freestanding Range','','Other','130 - Shepherd','SHEPHERD PRIMARY SCHOOL','SHEPHERD HIGH SCHOOL','SHEPHERD MIDDLE SCHOOL','Accompany,Appointment Required,Vacant/Unoccupied','Seller','1','Ranch','Winding Creek #2','684','1.7852','Septic Tank,Well','1985','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215086590','1669649791','215086590','2022-11-26T18:52:58.650','2170904','Cynthia Corder','JPAR - The Sears Group','','','29.708210','-96.544514','32','78934','7','248800.00','Active','Prairie','940','Street','Columbus','2','0','3','1546','Single-Family','SELLER CONCESSION OFFERED-buy down interest rates! Spacious and nicely renovated home has it all! 2022 Renovations include new kitchen and bathrooms, electrical, walls, interior/ exterior paint, all new fixtures, ceiling fans, flooring, blinds and water heater. Roof only one year old. Open concept kitchen has new stove and DW, granite counters and lots of storage including a breakfast bar. Bathrm has been remodeled w/ tile showers all new fixtures and ceramic tiles. Primary bath is completely new.The spacious living/dining room has built-ins and lots of light! All new LVP flooring throughout with new carpet in the bedrooms. Primary bedroom has dbl closets w/a large walk in closet. The mud room/hall near the entry is a perfect landing space for all of the kids stuff! The large fenced backyard and huge car port offer convenient off street parking. The workshop has endless possibilities. The laundry inside near the bedrooms is convenient. Great investment for airbnb or long-term rental.','0.2512','56','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','Wood Burning Fireplace','1','','Central Gas','0','BLK 60 LT PT 4 COLUMBUS HOUSE & BLDG','Subdivision Lot','10942','Appraisal District','','','0','','2','Electric Oven','0','','','Electric Range','','Other','188 - Columbus','COLUMBUS ELEMENTARY SCHOOL','COLUMBUS HIGH SCHOOL','COLUMBUS JUNIOR HIGH SCHOOL','Lockbox Front,No Supra Keybox,Vacant/Unoccupied','Appraisal','1','Traditional','Columbus','1560','1.8359','Public Sewer,Public Water','1945','Appraisal'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215102413','1669649791','215102413','2022-11-26T17:43:11.437','43773454','Jillian Lara','CB&A, Realtors-Katy','','','29.720131','-95.831312','8','77494','5','775000.00','Active','Piper Shadow','4411','Lane','Katy','4','0','5','4521','Single-Family','FALL IN LOVE with Piper Shadow featuring 5 bedrooms, 4 baths, swimming pool, on a TEXAS SIZED LOT, nestled in the heart of Pine Mill Ranch. Handsome wood flooring greets you at your entryway, leading you past your grand staircase into your cozy living room with picturesque views of your swimming pool and backyard. Piper Shadow is complete with an office, media AND game room, 2 pantries, yes 2 PANTRIES, double ovens, stainless steel, oversized laundry room, dining room with specialty lighting, large and spacious guest bedrooms, his and hers closets in master bedroom, granite countertops, 3 car garage, water softener and luxurious 6in baseboards. Easy Peasy access to 1463, I-10, Westpark Tollway, HWY 99. Never flooded.**Interior photos coming soon. Conflicting schedules over the holiday. Feel free to call agent.**','0.3254','36','','','Washer Connections','','Mud,Sellers Disclosure','1','Gaslog Fireplace','1','Katy - Southwest','Central Gas,Zoned','1','PINE MILL RANCH SEC 25, BLOCK 1, LOT 24','Subdivision Lot','14176','Appraisal District','','750','0','','3','Convection Oven,Double Oven,Gas Oven','1','In Ground','','Gas Cooktop','','Composition','30 - Katy','KEIKO DAVIDSON ELEMENTARY SCHOOL','TOMPKINS HIGH SCHOOL','TAYS JUNIOR HIGH SCHOOL','Appointment Required,Lockbox Right Side,Supra Keybox','Appraisal District','2','Traditional','Pine Mill Ranch Sec 25','16090','2.7845','Public Sewer,Public Water,Water District','2013','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215103776','1669649791','215103776','2022-11-26T17:59:38.747','17980546','Meharena Tukabo','eXp Realty, LLC','','','29.517404','-95.781239','17','77469','6','335000.00','Active','Vail Springs','3808','Drive','Rosenberg','2','0','3','','Single-Family','Located in the laidback city of Rosenberg, Tx. This Hanover was built by Lennar\'s home. Sendero is a masterplan community with collections of new homes for sale that is surrounded by local attractions and amenities. The Community is just minutes from I-69, providing easy access to downtown Houston, Sugarland, and Richmond as well as local restaurant, retail store, and entertainment venue. The Seaborn Creek Regional sports complex is just around the corner, and down the road, residents will find shopping centers, Such as the Brazos Town Center and Greatwood Country shop','0.1656','30','','','','','Sellers Disclosure','','','','Fort Bend South/Richmond','Central Gas','1','SENDERO SEC 2, BLOCK 1, LOT 12','Subdivision Lot','7215','Appraisal District','','756','0','','2','','0','','','','','Composition','33 - Lamar Consolidated','MEYER ELEMENTARY SCHOOL (LAMAR)','RANDLE HIGH SCHOOL','WRIGHT JUNIOR HIGH SCHOOL','Appointment Required,Lockbox Front','','1','Traditional','Sendero Sec 2','1249','2.9748','Water District','2022','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215104210','1669649791','215104210','2022-11-26T18:25:45.333','67435282','Julia Pecina','Camelot Realty','','','29.872986','-95.650836','21','77084','4','279900.00','Active','Honey Harvest','6610','Lane','Houston','2','1','4','2245','Single-Family','Welcome to Sommerall!! 6610 Honey Harvest is a beautifully maintained, move-in ready home. It bodes 4 bedrooms with the primary suite downstairs. Each bedroom is spacious with ample closet space. Second floor living area would make a great play room or secondary living room. Kitchen opens up to the living space and breakfast nook. Seated counter space off of the kitchen provides extra seating for your large family. This house has a great layout for entertainment and gatherings. The refrigerator, washer and dryer and all the mounted TV\'s are included! Neighborhood is conveniently located to 290 W & Hwy 6 and the area is growing quickly! You can\'t beat this deal. Schedule your showing today!!','0.0723','8','','','Gas Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','','','Bear Creek South','Central Gas','1','LT 24 BLK 1 SOMMERALL PARK SEC 1','Subdivision Lot','3149','Appraisal District','','600','0','','2','Electric Oven','0','','','Gas Cooktop','','Composition','13 - Cypress-Fairbanks','HOLMSLEY ELEMENTARY SCHOOL','LANGHAM CREEK HIGH SCHOOL','KAHLA MIDDLE SCHOOL','Lockbox Front,Request Online Appointment,Vacant/Unoccupied','Appraisal District','2','Contemporary/Modern,Craftsman,Other Style','Sommerall Park Sec 1','6519','2.641','Public Sewer,Public Water','2016','Appraisal District'); --> New record created successfully